I created a test package [FLAT FILE SOURCE] to [OLEDB DESTINATION]. I'm using IBMA400 OLE DB Provider. This works fine in my DEVELOPER machine but gets an error in PRODUCTION Any ideas would be appreciated. Thanks [OLE DB Destination [30]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E00. Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination" (30) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. Error: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited.

Please provide more information about your development and server environments. OSes, SQL versions/editions/bitnesses... Please post how you are executing the package in both environments. Please also post the start of the package execution output, and any other warnings or errors shown. Talk to me now on

I'm running/debugging both test package using VS 2005. DEVELOPER: Win XP PRO Version 2002 SP3 9.00.1399.06 RTM Developer Edition (SQL Server 2005) PRODUCTION: Win 2003 Server Enterprise x64 Edition SP2 9.00.4035.00 SP3 Enterprise Edition (64-bit) (SQL Server 2005) SSIS package "Package.dtsx" starting. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning. Information: 0x402090DC at Data Flow Task, Flat File Source [1]: The processing of file "D:\DOWNLOAD\CO011011.csv" has started. Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning. Information: 0x402090DE at Data Flow Task, Flat File Source [1]: The total number of data rows processed for file "D:\DOWNLOAD\CO011011.csv" is 3. Error: 0xC0202009 at Data Flow Task, OLE DB Destination [30]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E00. Error: 0xC0047022 at Data Flow Task: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination" (30) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. Error: 0xC0047021 at Data Flow Task: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited. Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning. Information: 0x402090DD at Data Flow Task, Flat File Source [1]: The processing of file "D:\DOWNLOAD\CO011011.csv" has ended. Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning. Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "OLE DB Destination" (30)" wrote 0 rows. Task failed: Data Flow Task Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. SSIS package "Package.dtsx" finished: Failure.

I tried running the solution by making Run64BitRuntime = False but I get the same error.

This flag has no effect outside BIDS. I assume you have a driver issue. If you execute your job using the SQL Agent then set the 32 bit mode on, otherwise ensure you are calling the 32 bit dtexec utility.Arthur My Blog

I would also recommend that you patch your developer machine to SP3. Talk to me now on

I've been researching an answer to my issue since yesterday and today but I couldn't find one (that worked). I even tried to change the OLEDB provider and used MS OLE DB Provider for DB2 instead of IBMs but I got the same error. I decided to create a script instead that writes the records to the AS400 using IBMDA400 OLEDB provider since I needed to finish my project. *sigh*

So I did my script and placed my package on the SQL Server. Tested with SQL Server agent and everything went smoothly. *sigh of relief I still have a job* (hahaha) So this morning, I decided to research more for a resolution to my OLEDB issue. I decided to use the provider IBMDASQL. I get the same error using [SQL COMMAND] access mode. HOWEVER, when I switched to [TABLE or VIEW] access mode, I was able to write back the records to AS400. The [TABLE or VIEW] access mode does not work for IBMDA400 provider though. I get the error below: Error at Data Flow Task [IBMDA400 Destination [837]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "IBMDA400 File Rowset" Hresult: 0x80004005 Description: "CPF4328: Member [MyTable] not journaled to journal *N. ". Error at Data Flow Task [IBMDA400 Destination [837]]: Opening a rowset for "[MyTable]" failed. Check that the object exists in the database. ----------------------------- ADDITIONAL INFORMATION: Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)

Have you seen this discussion ?SSIS Tasks Components Scripts Services | http://www.cozyroc.com/