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