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...
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 ,
Recently we did a physical db server migration with the same setup. we built a new db server and then old db server decommissioned.
The setup is like below.
OS Server: windows server 2019
source DB server: SQL Server 2017
Destination : AS400 db2 databse V7R3
SSIS jobs which are SQL SERVER 2012 deployed packages are running fine before migration.
After migration same SSIS Jobs are failing because we don't have same version of DB2OLEDBV4 in new db server. And SQL SERVER 2012 deployed SSIS packages supports only DB2OLEDB V4 . And