Forum Discussion
Indrashish
Sep 03, 2023Copper Contributor
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 c...
olafhelper
Sep 04, 2023Bronze 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.