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: 0×80004005.
An OLE DB record is available. Source: “Microsoft SQL Server Native Client 10.0″ Hresult: 0×80004005 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
Advertisement
Like this:
Be the first to like this post.
About john.dacosta
I am a Database Consultant based in South Florida. I specialize in SQL Server Development and Administration. I have worked on projects including data archival, log shipping, SQL Server installation, performance tuning, database mirroring, disaster recovery and more recently data integration. Currently my role as a consultant has had me add focus to the particularly important subject of Documentation, Quality, Timeliness and Cross-Training within the realm of Technology Delivery.
