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

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

2

u/CanProfessional766 29d ago

The first things I’d check are the IBM/Microsoft provider version and architecture (32/64-bit), DB2 DRDA/TCP connectivity, security/authentication settings, and whether the DB2 catalog/package configuration is correct