MS SQL Server DTS - SSIS Import & Export Wizard

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SSIS Import & Export Wizard - SQL 2005 with AS400

Kam

2005-09-28, 3:24 am

When I run the SQL Server Import and Export Wizard for SQL 2005 June and the
data source is from [IBM DB2 UDB for iSeries OLEDB Provider], I got the error
[column information for the source and the destination data could not be
retrieved, or the data types of source columns were not mapped correctly to
those available on the destination provider].

All fields in the AS400 tables got the following errors, [The data type
could not be assigned to the column "xxxxx" in Microsoft OLE DB Provider for
SQL Server].

There is no problem in SQL 2000.
Is there any way that I can overcome the above errors.

Sponsored Links