Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
IBM OLE DB provider for DB2 not listed in SSIS 2008

Answered IBM OLE DB provider for DB2 not listed in SSIS 2008

  • Friday, March 02, 2012 11:28 PM
     
     
    Sign In to Vote
    0

    Hello,

    I am trying to create a conection for a DB2 database, I've installed SSIS 2008 in my remote desktop (Microsoft Server 2003) and also I have DB2 installed. But I cannot see listed the IBM OLE DB provider for DB2. Any idea?

    Thank you in advance.

     

All Replies

  • Saturday, March 03, 2012 12:13 AM
     
     Proposed
    Sign In to Vote
    0
    Do you have SQL Server 2008 Enterprise Edition installed.  I think this is required to use the IBM OLE DB provider for DB2.

    Carla Sabotta

     
  • Monday, March 05, 2012 1:55 AM
    Moderator
     
     
    Sign In to Vote
    0

    Download and install the DB2OLEDB.exe from this address:

    http://go.microsoft.com/fwlink/?LinkId=123713&clcid=0x409

    http://www.rad.pasfu.com

     
  • Monday, March 05, 2012 7:17 AM
     
     Proposed
    Sign In to Vote
    0
    Do you have SQL Server 2008 Enterprise Edition installed.  I think this is required to use the IBM OLE DB provider for DB2.

    Carla Sabotta

    Seems like you're right.
    The Microsoft SQL Server 2008R2 feature pack - that has the download for the DB2 OLE DB provider - says the following:

    The Microsoft OLE DB Provider for DB2 Version 3.0 offers a set of technologies and tools for integrating vital data stored in IBM DB2 databases with new solutions based on Microsoft SQL Server 2008 R2 Enterprise Edition and Developer Edition.

    http://www.microsoft.com/download/en/confirmation.aspx?id=16978

    MCTS, MCITP - Please mark posts as answered where appropriate.
    Answer #1: Have you tried turning it off and on again?
    Answer #2: It depends...

     
  • Monday, March 05, 2012 4:02 PM
     
     
    Sign In to Vote
    0
    Hello, yes I have it installed

    Cristal Leos

     
  • Monday, March 05, 2012 4:03 PM
     
     
    Sign In to Vote
    0
    I'm looking for the IBM OLE DB provider, I already have the option for Microsoft OLE DB Provider for DB2 but it does not work as expected

    Cristal Leos

     
  • Tuesday, March 06, 2012 10:41 PM
     
     Answered
    Sign In to Vote
    0
    I'm looking for the IBM OLE DB provider, I already have the option for Microsoft OLE DB Provider for DB2 but it does not work as expected

    Cristal Leos

    Need to look for IBMDADB2 ... from IBM. You need to have IBM DB2 client installed

    maybe this will help

    http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.swg.im.dbclient.install.doc%2Fdoc%2Fc0022615.html

    • Marked As Answer by cristal leos Tuesday, March 06, 2012 11:16 PM
    •  
     
  • Tuesday, March 06, 2012 11:16 PM
     
     
    Sign In to Vote
    0
    Thank you!

    Cristal Leos