Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Location
    Athens, Greece
    Posts
    22

    Looking for alternate data transfer method

    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

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    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.
    George
    Home | Blog

  3. #3
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    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.

  4. #4
    Join Date
    Nov 2007
    Location
    Athens, Greece
    Posts
    22
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •