How to access a DB2 data source in SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » How to access a DB2 data source in SSIS

How to access a DB2 data source in SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

Ganesh Srinivasan-267334

Posted Friday, October 07, 2005 8:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 16, 2006 3:29 PM
Points: 3, Visits: 1

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

Post #227133

Site Owners

Posted Monday, October 10, 2005 8:00 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040, Visits: 1

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

Post #227625

Kirk Haselden

Posted Monday, October 10, 2005 7:32 PM

Valued Member

Group: General Forum Members
Last Login: Friday, March 14, 2008 4:00 AM
Points: 63, Visits: 3

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

Post #227807

Ganesh Srinivasan-267334

Posted Thursday, October 13, 2005 7:04 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 16, 2006 3:29 PM
Points: 3, Visits: 1

Hi,

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

Thanks

Post #228628

Scott-253931

Posted Monday, December 19, 2005 12:17 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 21, 2009 9:20 AM
Points: 9, Visits: 16

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?

Post #245289

Paul Misoni

Posted Friday, December 23, 2005 12:53 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 05, 2011 1:18 PM
Points: 4, Visits: 41

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).

Post #246501

quasar_phoenicis

Posted Monday, November 08, 2010 2:13 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, June 17, 2013 7:46 PM
Points: 38, Visits: 232

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!

Post #1017462

Greg Edwards-268690

Posted Friday, February 11, 2011 11:26 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 2:46 PM
Points: 805, Visits: 5,253

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

Post #1062754

« Prev Topic | Next Topic »

Permissions