Gurus,

I've got 2 servers running, one with DB2/400 and the other SQLSVR 2005, with a 100Mbps line between them.

I'm trying to transfer a bunch of data from DB2/400 to the other server. I actually have an ETL application to do this (Sunopsis), and the recommended practice by this app is to use bulk load.

A little dissection of the ETL steps show that the extraction from DB2 to a flat file is running at close to 50 minutes to generate this file (JDBC connection).

I tested with SQLSVR's DTS Import/Export feature, and it took about 10 minutes.

What gives?