Forum Discussion
Microsoft OLE DB Provider for DB2 version 4.0
Hi All,
I am looking for Microsoft OLE DB Provider for DB2 Version 4.0 update 9.0.1428.0 . I think this is a part of SQL Server 2012 Service pack 1 feature . I tried to get these software's but I am unable to get it.
Could you please help me how and where can i download. Kindly help!
Thanks,
Sreenivasa.
5 Replies
tschary , latest version is 7, use that one.
Download Microsoft OLE DB Provider for DB2 Version 7.0 from Official Microsoft Download Center
Hi olafhelper , we have SQL Server 2012 SSIS packages supports only updated Microsoft DB2 4.0 OLE db provider. I have tried in Visual studio for DB2 other versions 5.0,6.0 &7.0 but no luck. Pease help me to get the same version.
- "But no luck" means what in detail? With that less on information no one can guess.
I never noticed that SSIS cares about any OleBD driver version.
Hi olafhelper , Thanks for the response. Our environment is Databases are migrated from SQL Server 2012 to SQL Server 2017 and the SSIS packages are deployed and still running with SQL Server 2012. Those packages are importing data from AS400 into SQL database. So when i try to use DB2 version 5.0 or 6.0 or 7.0 the DB2 provider is not supporting and unable to import data from AS400 (V7R3).
last two months we did data center migration , the old SQL server with same setup had worked with DB2 version 4.0. with updated number 9.01428.0.
I have found the initial version of DB2 4.0 - 9.0.1390.0 but it is not working for few columns while importing data from AS400 into SQL server and Microsoft had released 9.0.1428.0 which will fix those columns.
Please help me to get the same version.
Could you please help.
Thanks,
Sreenivasa
