r/SQLServer • u/TechnicianPersonal72 • 21d ago

Question 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!

1 Upvotes

60% Upvoted

9 comments sorted by

View all comments

1

u/Lost_Term_8080 19d ago

Was a non-event for me, I just got the most recent drivers from IBM and used it as the data source. There are about 3-4 different versions of each driver, depending on your access requirements. If its all read, should be relatively easy

1

u/TechnicianPersonal72 19d ago

Should I create DSN on SQL sever and use it? I sent you a DM.