SSIS Connection to DB2
-
Need download links for a OLEDB provider that i can use to connect to DB2 using SQL Server 2008 Standard Edition.
My problem is Microsoft OLE DB Provider for DB2 does not work with standard edition of SQL Server 2008.
If IBM DB2 Provider can be downloaded for free and would work on SQL Standard Edition do let me know. Please post download links and set up procedure to get this working. Appreciate any help.
-
I believe that if you install the IBM DB2 Client on the machine(s) that you a using SSIS on it installs the driver.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ -
Please post links from where I can download this and whihc version i would need.
-
harry.sh16 (5/23/2011)
Please post links from where I can download this and whihc version i would need.What version of DB2 are you using?
I performed several goggle searches the closest that got was links to the IBM DB2 Client Install.
If you want the Oracle DB2 OLDB Provider you must install the Oracle Client.
Have you tried goggle?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ -
Db2 version is 8.xx. Yes googled no luck. Need links to download the drivers to get this working. I have 64 bit windows OS on my desktop.
-
You should try installing the Client. Perhaps the application Development Client
That should include the Driver that you are looking for.
This may be trial and error. You may want to try it.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ -
did anyone find any answer to this?I am also stuck @ finding driver for db2.I also have an standard edition.Please help!!!!!
-
I believe the software is called DB2 Connect, and it aint free..
http://www-01.ibm.com/software/data/db2/db2connect/[/url]
Depending on the size of your company you might already be licensed for this.
I used to use a package by HIT Software that worked really well, not cheap..
http://www.hitsw.com/products_services/oledb.html
As far as free, other than the MS one that is limited to Enterprise Edition, I think you are screwed.
Sorry man..
CEWII
-
harry.sh16 (5/23/2011)
Need download links for a OLEDB provider that i can use to connect to DB2 using SQL Server 2008 Standard Edition.My problem is Microsoft OLE DB Provider for DB2 does not work with standard edition of SQL Server 2008.
If IBM DB2 Provider can be downloaded for free and would work on SQL Standard Edition do let me know. Please post download links and set up procedure to get this working. Appreciate any help.
You need to download IBM Data Server Runtime Client. Try downloading from here.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
Good information Cozy, I wasn't aware of that one..
CEWII
-
Can you explain the details how install and connect to db2 through ssis it would be very helpful....
-
raghudatta (6/17/2011)
Can you explain the details how install and connect to db2 through ssis it would be very helpful....Have you client on the link provided to install the client?
After installing the client you need to create a connection the IBM data Source?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply