Hi All!

the case:

-4 DB2/400 systems in 4 countries.

the need:

-Build a centralised DW having all the details of the tables.

the target:

-DW in MS SQL2008, and the tool is COGNOS 8.4

the problem:

-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'

the solution:

ALTERNATE METHOD of getting the data...

I am open to ideas...

thanks

Elias

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.

thanks guys!!

The process that i am thinking is
-transfer the data to intermeddiate files (csv?)
-Zip them
-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

Elias