Hi,
I am undergoing a migration excercise from SQL SERVER 2000 to UDB DB2 8.1

We have some tables in SQL SERVER which are BLOB and VARBINARY.
What would be good way to extract that data from SQL SERVER and load it into DB2.

I tried using BCP at the sql server end to export the data from the tables and then I used an import at the DB2 end to load the data in.
The import was successful but then the import also added a few characters to the BLOB datas.

Any suggestions would be greatly appreciated.

-Soumil

How about using DB2 II with MS-SQL Wrapper.
It import SQL-Server data ( text, Image, .. ) with DB2 CLOB or BLOB.