Forum Discussion

tschary's avatar
tschary
Copper Contributor
May 30, 2024

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's avatar
tschary
Copper Contributor
May 31, 2024

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

 

 

Resources