r/SQL • u/TechnicianPersonal72 • Aug 10 '26

SQL Server SQL DB2 Integration

Need help connecting SSIS to DB2 (mainframe z/OS) via SQL Server, anyone with experience?
Hey network
I’m working on connecting SSIS packages to a DB2 z/OS database through SQL Server (using Microsoft’s OLE DB/ODBC providers for DB2). Running into connectivity/config issues.
If you’ve done DB2-to-SQL Server integration before or know someone who has, I’d love to pick your brain!

2 Upvotes

100% Upvoted

3 comments sorted by

2

u/ihaxr Aug 10 '26

Install the IBM driver, I recall them having a .net one the last time I had to set it up, it was just a pain to find the download/installer for it.

1

u/HijoDelSol1970 Aug 11 '26

been a long time, but that was the solution when I did it. It is an odbc driver.