Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005

Check if the RetainSameConnection Option is set to true or false for your Database Connection.
I was attempting to Update data by using a Data Flow Transformation
OLE DB Source –> OLE DB Command

When the RetainSameConnection was set to TRUE, I encountered errors.
When the RetainSameConnection was set to FALSE, the package functions as expected.
Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: “Microsoft SQL Server Native Client 10.0” Hresult: 0x80004005 Description: “Syntax error, permission violation, or other nonspecific error”.

http://connect.microsoft.com/SQLServer/feedback/details/682902/ssis-failing-pre-execution-when-retainsameconnection-is-set-to-true

 

 

Advertisements

2 thoughts on “Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005

  1. Hi John,I am facing one issue in SSIS package.Trying to pass parameter.But it is showing error like this

    “Error at Stage Data [LIR [221]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
    An OLE DB record is available. Source: “Microsoft SQL Server Native Client 10.0” Hresult: 0x80004005 Description: “Syntax error, permission violation, or other nonspecific error”.”

    Can you please help me in this situation.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s