question

slowbsure avatar image
slowbsure asked

using IXF (db2 export) with SSIS

Hi, is there an automated way to import ixf files into SQL server using SSIS? IXF is an export format from DB2.
db2
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Venkataraman avatar image
Venkataraman answered
There is no native way to do this. You can connect to DB2 database and import the data as mentioned here: http://www.bidn.com/blogs/PatrickLeBlanc/ssis/700/connecting-to-db2-using-ssis Also refer to http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70795 for similar problem
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.