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