Error Parsing file while comitting stored procedure to TFS.

JAlessi

I get this error on two of my stored procedures...

"There was an error parsing the file "...\xxxxxxx.sql" at line 6, column 7 near the text ."

Both stored procedures are valid SQL code and execute flawlessly.  I have excluded the two stored procedures and removed them from the local workspace & the TFS repository.  That let me continue working without committing these two source files.  Obviously this is not the preferred situation, what should I do to get past this?

Peter_Laws

Hello JAlessi,

Thank you for your query, as it's a parser fault we'll need to examine the code in question.
I will raise a support ticket for you to securely upload an example; if the resolution is useful to the community I'll add that here at the end.

Kind regards,
Peter

Peter_Laws

Thank you for helping us identify the parser issue, the patch should be released shortly.
As an interim solution, please use single quotes on the origin reference for bulk insert statements.

Kind regards,
Peter

Peter_Laws

This fix is now available in SQL Source Control.

Kind regards,
Peter