Forum Discussion

Indrashish's avatar
Indrashish
Copper Contributor
Sep 03, 2023

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

  • Indrashish's avatar
    Indrashish
    Copper 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,

  • olafhelper's avatar
    olafhelper
    Bronze 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.

Resources