I am attempting to transfer a table from an AS400 to SQL Server 2005 through SSIS. I am using the IBM DB2 UDB ISeries IBMDASQL OLEDB Provider as the source connector. I have tried to set up the source connector using the Table or View option but it says that No Tables Could Be Loaded. I can specify an SQL command and it shows the columns and appears to set up correctly except for showing a warning indicating that it cannot retrieve the column code page information from the OLEDB provider. When I run the job, it fails with the following error: Name: OnError Computer: BAMBIG1 Operator: BAM\infausr Source Name: Package Source GUID: {10456BAE-F004-4935-A9CC-0D1257272F11} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: Thread "WorkThread0" received a shutdown signal and is terminatingThe user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.The full output of the run is shown below. Any help you can provide will be GREATLY Appreciated! I am at my wits end trying to get data from this AS400. Start Time: 2005-11-03 15:27:29 End Time: 2005-11-03 15:27:29End LogLog: Name: OnError Computer: BAMBIG1 Operator: BAM\infausr Source Name: Package Source GUID: {10456BAE-F004-4935-A9CC-0D1257272F11} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. Start Time: 2005-11-03 15:27:29 End Time: 2005-11-03 15:27:29End LogError: 2005-11-03 15:27:29.29 Code: 0xC0047039 Source: Data Flow Task DTS.Pipeline Description: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing thepipeline to shutdown.End ErrorLog: Name: OnError Computer: BAMBIG1 Operator: BAM\infausr Source Name: Data Flow Task Source GUID: {22F39B55-241A-4476-90ED-1512E6F014E7} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: Thread "WorkThread0" has exited with error code 0xC0047039. Start Time: 2005-11-03 15:27:29 End Time: 2005-11-03 15:27:29End LogLog: Name: OnError Computer: BAMBIG1 Operator: BAM\infausr Source Name: Package Source GUID: {10456BAE-F004-4935-A9CC-0D1257272F11} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: Thread "WorkThread0" has exited with error code 0xC0047039. Start Time: 2005-11-03 15:27:29 End Time: 2005-11-03 15:27:29End LogError: 2005-11-03 15:27:29.62 Code: 0xC0047021 Source: Data Flow Task DTS.Pipeline Description: Thread "WorkThread0" has exited with error code 0xC0047039.End ErrorLog: Name: OnInformation Computer: BAMBIG1 Operator: BAM\infausr Source Name: Data Flow Task Source GUID: {22F39B55-241A-4476-90ED-1512E6F014E7} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: Post Execute phase is beginning. Start Time: 2005-11-03 15:27:29 End Time: 2005-11-03 15:27:29End LogLog: Name: OnInformation Computer: BAMBIG1 Operator: BAM\infausr Source Name: Package Source GUID: {10456BAE-F004-4935-A9CC-0D1257272F11} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: Post Execute phase is beginning. Start Time: 2005-11-03 15:27:29 End Time: 2005-11-03 15:27:29End LogLog: Name: OnProgress Computer: BAMBIG1 Operator: BAM\infausr Source Name: Data Flow Task Source GUID: {22F39B55-241A-4476-90ED-1512E6F014E7} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: Post Execute Start Time: 2005-11-03 15:27:29 End Time: 2005-11-03 15:27:29End LogProgress: 2005-11-03 15:27:29.93 Source: Data Flow Task Post Execute: 0% completeEnd ProgressLog: Name: OnProgress Computer: BAMBIG1 Operator: BAM\infausr Source Name: Data Flow Task Source GUID: {22F39B55-241A-4476-90ED-1512E6F014E7} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: Post Execute Start Time: 2005-11-03 15:27:29 End Time: 2005-11-03 15:27:29End LogProgress: 2005-11-03 15:27:30.10 Source: Data Flow Task Post Execute: 50% completeEnd ProgressLog: Name: OnProgress Computer: BAMBIG1 Operator: BAM\infausr Source Name: Data Flow Task Source GUID: {22F39B55-241A-4476-90ED-1512E6F014E7} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: Post Execute Start Time: 2005-11-03 15:27:30 End Time: 2005-11-03 15:27:30End LogProgress: 2005-11-03 15:27:30.26 Source: Data Flow Task Post Execute: 100% completeEnd ProgressLog: Name: OnInformation Computer: BAMBIG1 Operator: BAM\infausr Source Name: Data Flow Task Source GUID: {22F39B55-241A-4476-90ED-1512E6F014E7} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: Cleanup phase is beginning. Start Time: 2005-11-03 15:27:30 End Time: 2005-11-03 15:27:30End LogLog: Name: OnInformation Computer: BAMBIG1 Operator: BAM\infausr Source Name: Package Source GUID: {10456BAE-F004-4935-A9CC-0D1257272F11} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: Cleanup phase is beginning. Start Time: 2005-11-03 15:27:30 End Time: 2005-11-03 15:27:30End LogLog: Name: OnProgress Computer: BAMBIG1 Operator: BAM\infausr Source Name: Data Flow Task Source GUID: {22F39B55-241A-4476-90ED-1512E6F014E7} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: Cleanup Start Time: 2005-11-03 15:27:30 End Time: 2005-11-03 15:27:30End LogProgress: 2005-11-03 15:27:30.57 Source: Data Flow Task Cleanup: 0% completeEnd ProgressLog: Name: OnProgress Computer: BAMBIG1 Operator: BAM\infausr Source Name: Data Flow Task Source GUID: {22F39B55-241A-4476-90ED-1512E6F014E7} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: Cleanup Start Time: 2005-11-03 15:27:30 End Time: 2005-11-03 15:27:30End LogProgress: 2005-11-03 15:27:30.65 Source: Data Flow Task Cleanup: 50% completeEnd ProgressLog: Name: OnProgress Computer: BAMBIG1 Operator: BAM\infausr Source Name: Data Flow Task Source GUID: {22F39B55-241A-4476-90ED-1512E6F014E7} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: Cleanup Start Time: 2005-11-03 15:27:30 End Time: 2005-11-03 15:27:30End LogProgress: 2005-11-03 15:27:30.76 Source: Data Flow Task Cleanup: 100% completeEnd ProgressLog: Name: OnInformation Computer: BAMBIG1 Operator: BAM\infausr Source Name: Data Flow Task Source GUID: {22F39B55-241A-4476-90ED-1512E6F014E7} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: "component "SQL Server Destination" (1064)" wrote 0 rows. Start Time: 2005-11-03 15:27:30 End Time: 2005-11-03 15:27:30End LogLog: Name: OnInformation Computer: BAMBIG1 Operator: BAM\infausr Source Name: Package Source GUID: {10456BAE-F004-4935-A9CC-0D1257272F11} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: "component "SQL Server Destination" (1064)" wrote 0 rows. Start Time: 2005-11-03 15:27:30 End Time: 2005-11-03 15:27:30End LogLog: Name: User:PipelineBufferLeak Computer: BAMBIG1 Operator: BAM\infausr Source Name: Data Flow Task Source GUID: {22F39B55-241A-4476-90ED-1512E6F014E7} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: component "OLE DB Source" (1) leaked a buffer with ID 1 of type 1with 0 rows and a reference count of 1. Start Time: 2005-11-03 15:27:31 End Time: 2005-11-03 15:27:31End LogLog: Name: OnTaskFailed Computer: BAMBIG1 Operator: BAM\infausr Source Name: Data Flow Task Source GUID: {22F39B55-241A-4476-90ED-1512E6F014E7} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: (blank) Start Time: 2005-11-03 15:27:31 End Time: 2005-11-03 15:27:31End LogLog: Name: OnPostExecute Computer: BAMBIG1 Operator: BAM\infausr Source Name: Data Flow Task Source GUID: {22F39B55-241A-4476-90ED-1512E6F014E7} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: (blank) Start Time: 2005-11-03 15:27:31 End Time: 2005-11-03 15:27:31End LogLog: Name: OnWarning Computer: BAMBIG1 Operator: BAM\infausr Source Name: Package Source GUID: {10456BAE-F004-4935-A9CC-0D1257272F11} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: The Execution method succeeded, but the number of errors raised (5) 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. Start Time: 2005-11-03 15:27:31 End Time: 2005-11-03 15:27:31End LogWarning: 2005-11-03 15:27:31.49 Code: 0x80019002 Source: Package Description: The Execution method succeeded, but the number of errors raised(5) reached the maximum allowed (1); resulting in failure. This occurs when thenumber of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.End WarningLog: Name: OnPostExecute Computer: BAMBIG1 Operator: BAM\infausr Source Name: Package Source GUID: {10456BAE-F004-4935-A9CC-0D1257272F11} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: (blank) Start Time: 2005-11-03 15:27:31 End Time: 2005-11-03 15:27:31End LogLog: Name: PackageEnd Computer: BAMBIG1 Operator: BAM\infausr Source Name: Package Source GUID: {10456BAE-F004-4935-A9CC-0D1257272F11} Execution GUID: {461EBFFB-F3D5-4BD6-A3C6-7DB796EFFA93} Message: End of package execution. Start Time: 2005-11-03 15:27:31 End Time: 2005-11-03 15:27:31End LogDTExec: The package execution returned DTSER_FAILURE (1).Started: 3:27:16 PMFinished: 3:27:31 PMElapsed: 15.797 secondsPress any key to continue . . .Thank You,

.First you may want to check some previous posts on this topic to see whether they help. http://forums.microsoft.com/msdn/showpost.aspx?postid=107266&siteid=1 .Also, if possible please try to download the new MS OLEDB Provider for DB2 after we launch SQLServer2005 (11/7/05), that's the provider we fully support in SSIS and have resources from the provider team to help if any problems. Please let us know whether that works for you if you get a chance to switch.ThanksWenyang

Do you have a link of where the new MS OLEDB Provider for DB2 can be downloaded?Thanks!

I see you already got the answer yourself :) Let's post here anyway for people who are interested in this thread http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en ThanksWenyang

Very good news... I have been waiting a long time for this, and it can really help me... But wait?! I cannot use this provider with the Standard Edition?

To use the DB 2 provider, we do require that you possess a licensed copy of Microsoft SQL Server 2005 Enterprise Edition or Microsoft SQL Server 2005 Developer Edition software. This doesn't necessarily require that you have Enterprise installed on every client. For example, you could load an Enterprise server from a standard client. Perhaps you are licensed already?jkh

Uggghhhhh!!!! I was so happy to be able to download the DB2 Provider, but we use SQL Standard edition! Guess I am going to have to look into building a cusomt data source.

Just so you understand this is going to kill SQL server at our location. We have been doing DTS and SSIS from the 400 with great success for several years and all of a sudden out of the blue it quits working with SQL server 2005. Gee, now we have to buy an enterprise version to get a driver that will work. It's not enough that we buy a license for every machine in the company, have a server in every plant, now we have to buy enterprise edition on top just to do something we have been doing for years.

You can still use another driver than the "Microsoft OLE DB Provider for DB2", if you don't have Enterprise Edition. For instance, you can use the OLEDB/ODBC driver provided with Client Access for AS/400.

I have been trying to use that driver with no sucsess. It worked fine in SQL Server 2k but as soon as I upgrade the dev tools it quits.

In the Data Flow task, select the OLEDB source connector, right click and go to properties. In the custom properties section, set the 'AlwaysUseDefaultCodePage' property to True.

IBM DB2 UDB ISeries IBMDASQL OLEDB Providerwhere shud i get this?i jst move from development site... before this back in office i have this connection option under the connection manager... now it's gone...how? what shud i install to get it?

areankim, You'd need to get that from IBM. Either on the DB2 CDs, or from their Website.

i wonder why my office has all the provider... and my client side do not have.do i require to install Iseries Access for windows in order to get the OLE DB IBM db2 for i series?according to thishttp://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzaik/rzaikoledbprovider.htmam i looking at the rite thing?thnx in advance

Hello areankim, How did you solve this issue, I am looking for to download OLE DB IBM db2 for i series, since my package is developed using that driver in developement envirnonment i am not able to use other drivers to run that package in production, please let me know the solution. thanks