Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Importing data to SQL Server from a DB2 (PC/IXF) e

Author  Topic 

Starting Member

6 Posts

Posted - 2006-08-21 : 11:11:03
Hi All,

I want to transfer large amounts of data from a db2 server to my SQL Server. There is a feature in db2 which allows all files to be exported in PC/IXF format, any idea if SQL Server can import this kind of file format.

Any other ideas/suggestions on how I can do this..


Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-21 : 13:43:26
I think it is better with ordinary delimited text files, that you zip on DB2. FTP them and unzip and import at SQL Server.

Peter Larsson
Helsingborg, Sweden
Go to Top of Page

- Advertisement -