Post reply

How to access a DB2 data source in SSIS

  • October 7, 2005 at 8:25 am

    #166304

    Hi,

    In SSIS I don't see any data source component to connect to DB2 database.Even I don't find

    a OLE DB provider for DB2 inside OLE DB source component.ODBC Component is also not available.

    Can someone pls let me know how to access the DB2 source data?

    Thanks

    zzgani

  • October 10, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • October 10, 2005 at 7:32 pm

    #596423

    You can use the HIS DB2 provider. Also, SS2K5 is shipping with a DB2 provider in the box.

    K

  • October 13, 2005 at 7:04 am

    #597063

    Hi,

    Could you please elaborate the steps on how to access this HIS DB2 provider inside SSIS designer?

    Thanks

     

     

     

  • December 19, 2005 at 12:17 pm

    #610403

    I have SQL 2005 Standard edition installed (received from the Orlando Launch) After doing multiple searches.... I found a link to Microsoft for the "Microsoft OLEDB Provider for DB2". The problem I ran into was that it is for Enterprise or Developer editions. Not sure why it was limitied to just those two versions? Is there another download?

  • December 23, 2005 at 12:53 pm

    #611362

    Use the DataReader Source against your ODBC connection to DB2.  We use IBM's DB2 Connect software.

    Under Connection Managers, right-click and select "New Connection...".

    Choose ODBC.  New... Pick your ODBC connection from the drop-down list (as previously DSNs defined on your box)

    From there, I then select the radio button to "Use connection string" and then on "Build".  This brings up another window.  Select the database alias, User ID, and password.  Click OK.  After it connects, test the connection.

    I'm not sure this is the best way to do this, but it works for me (for now).

     

  • November 8, 2010 at 2:13 pm

    #1247893

    Hi, I ran into the same problem now. I tried using the ODBC Data source connection but I can't find the DB2 driver. does anyone know where to download the DB2 driver for SSIS 2005 standard edition/windows 7 OS?

    thanks!

  • February 11, 2011 at 11:26 am

    #1285844

    I ran across this while searching the site for my issue.

    http://www.sqlservercentral.com/blogs/sqldownsouth/archive/2010/5/26/connecting-to-db2-using-ssis.aspx

    There is a link to the driver if you haven't found it already.

    Greg E

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply