question

pvsrinivasrao avatar image
pvsrinivasrao asked

How to connect to DB2 Database from SSIS 2008

sorry to not to give much details, Can anyone please help me on How to connect to DB2 Database from SSIS 2008.
sql-server-2008ssisdb2
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Usman Butt avatar image
Usman Butt answered
Since it includes quite a few steps, the following links (with visuals) would help you http://geekswithblogs.net/13DaysaWeek/archive/2010/05/16/connecting-to-db2-from-ssis.aspx http://www.bidn.com/blogs/PatrickLeBlanc/ssis/700/connecting-to-db2-using-ssis
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Pavel Pawlowski avatar image
Pavel Pawlowski answered
In my previous Job I was successfully using the [IBM DB2 ODBC Driver][1]. Then once the ODBC connection is configured, you can use an OLE DB Driver for ODBC and use that for connecting the DB2. (Don't forget to define a system wide DSN. Other option is to define a Linked server again as OLE DB for ODBC and the use OPENQUERY selects in SSIS. I have used both methods on several systems with success. [1]: http://www-01.ibm.com/support/docview.wss?uid=swg27016878
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.