I see, you are using the Import Export Wizard. Sorry I missed that.
Not much you can do there.
I think it's time to jump in and create an SSIS package to do this transfer.
Unfortunately, I have found the IBM drivers to be very difficult to work with.
The MS OLEDB Provider for DB2 is much better. The only problem is that SQL Server must be the Enterprise version. Developer is OK for dev.
If you can't use MS' driver we can probably get the IBM working, but you need to create the SSIS package so that you can set these items.
I would definitely get the iSereis Navigator tool installed as well, it's the SSMS for DB2. Also called the iSeries Access for Windows. It comes with the iSeries OS so your AS400 group should be able to help you. It is very necessary to look around and explore data and meta-data for the tables that you will be pulling from.
Are you in a foreign country and are there foreign characters in this column?
Norman
DTS Package Search