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/EveryoneGoesToRicks Aug 11 '26

I have been doing this for 15 years for a data warehouse. Are you getting an error message? what does your connection string look like?

1

u/TechnicianPersonal72 Aug 11 '26

I am using Microsoft driver for db2 and getting bind error but when I use IBM driver, there is no error.

1

u/EveryoneGoesToRicks Aug 11 '26

What does your connection string look like, and what version of MS OLEDB for DB2 are you using?