var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Looking for alternate data transfer method
-4 DB2/400 systems in 4 countries.
-Build a centralised DW having all the details of the tables.
-DW in MS SQL2008, and the tool is COGNOS 8.4
-SSIS speeds with the MS OLE DB provider (which the fastest among ibm ole db and odbc) are not acceptable, although it is not a problem of SSIS but the VPNs'
ALTERNATE METHOD of getting the data...
I am open to ideas...
If DB2 can export to CSV then that's the route I would go down next.
BCP in SQL Server is very powerful (and fast!).
Alternatively - have you got the quick load option turned on in SSIS? This can dramatically increase performance.
You could use an integration tool with native DB2 connectivity (IBM DataStage for example?)
Or you could extract to an intermediate file first and transfer that to Windows. SSIS has support for converting EBCDIC and packed decimal data from a file.
You might get more help in the DB2 forum.
The process that i am thinking is
-transfer the data to intermeddiate files (csv?)
-transfer them from remote to local (ftp?
-use SSIS to get the csvs' from zipped files to sql server 2008
the problem is that i dont quite know how to do the first steps..So i suppose i 'll check in db2 forum