question

SharonStevens-5257 avatar image
0 Votes"
SharonStevens-5257 asked KranthiPakala-MSFT commented

Azure ADF Pipeline Copy Data - Incorrect syntax near

I have a very simple pipeline to load a 2 column dataset to SQL database. The preview of the source works fine. I am getting the following syntax error. I have NO Pre-copy script. It should auto create the table.

ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'Incorrect syntax near 'cd_sfobjmetaToSQLComposeRuntimeVariables'.',Source=,''Type=System.Data.SqlClient.SqlException,Message=Incorrect syntax near 'cd_sfobjmetaToSQLComposeRuntimeVariables'.,Source=.Net SqlClient Data Provider,SqlErrorNumber=102,Class=15,ErrorCode=-2146232060,State=1,Errors=[{Class=15,Number=102,State=1,Message=Incorrect syntax near 'cd_sfobjmetaToSQLComposeRuntimeVariables'.,},],'

Any assistance is appreciated

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SharonStevens-5257 avatar image
0 Votes"
SharonStevens-5257 answered KranthiPakala-MSFT commented

Found the issue where you put in the dataset dynamic content there was a space before @dataset().table_name

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Glad to know your issue was resolved @sharonstevens-5257. And thanks for sharing the root cause details as it could be beneficial for other community memebers.

Thank you

0 Votes 0 ·