Forum Discussion
Error in SSIS Package
Hi,
I am getting an error in OLE DB Source of my SSIS Package.
I am using an expression as the connection string and the user credentials as a project parameter.
Using the same credentials, I can connect using management studio.
But, in the SSIS package, I am getting the below error :
Exception from HResult : 0xC0202009
Error at DFT - Load_User [OLE_Src-****[38]] : SSIS Error Code DTS_E_OLEDBERROR. An OLEDB error has occured. Error Code : 0x80040E14.
An OLEDB record is available. Source : ''Microsoft SQL Server Native Client 11.0'' HResult : 0x80040E14 Description : "Statement(s) could not be prepared."
An OLEDB record is available. Source : ''Microsoft SQL Server Native Client 11.0'' HResult : 0x80040E14 Description : '' Incorrect syntax near '0'."
I am using SQL command from variable as the data access mode and '0' is the variable value.
This error is coming in all the DFT tasks. This package has worked earlier in production. I am trying to modify the query.
Regards
2 Replies
- IndrashishCopper Contributor
Hi,
My goal was to add the new additional column in the source and destination of the task...I was able to do so after hard-coding the modified sql query....after that, I was able to add the new column in the source and destination of the task and, saved it....then changed to the old configuration back....saved it,,,,,,then everything worked for me as I wanted,,,
Regards, - olafhelperBronze Contributor
: 0x80040E14 Description : '' Incorrect syntax near '0'."
I am using SQL command from variable as the data access mode and '0' is the variable value.
Indrashish , you get a clear SQL error message, debug your SSIS package and the final SQL statement for execution.