var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Slow writing to flat file
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.