How to Transfer data from AS400 to SQL 2005

Hi All,

I have to transfer AS400 files to Sql 2005 tables .For this I am using the DTS wizard. I am able to connect to AS400 Database and in the Wizard when I give the sql statement Select * from table1 the statement is parsed. In the next step however I am geting DTS unhandled exception with no error message.

"An error occured which the SQL Server Integration services wizard was not prepared to handle.
No error message available,result codeB_E_CANTCANCEL(0*80040E15).(System.Data)".

I am not able to proceed further. Pls let me know what I should do?

I am using IBMDB2 UDBFOR ISEREIS IBMDA400 OLE DB PROVIDER to connect to AS400 from the DTS wizard and IBM Client Access Tool to connect to AS400.

How can I transfer Data from AS400 files to Sql 2005 tables using the DTS wizard?

Regds,

Anu

What is the DTS wizard with respect to SSIS?|||

if you do a search you should find a few topics related to people trying to use the native OLE DB drivers to access AS/400 data. Most of us (me included) seem to have given up trying to solve the problem and are just using the IBM-provided ODBC driver instead.

Of course, this could mean your packages need some alteration since SSIS has some differences depending on the type of connection being used (e.g. Datareader vs. OLEDB sources).