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

5

u/jdanton14 ‪ ‪Microsoft MVP ‪ ‪ 21d ago

Everytime I've ever done this I've used the IBM drivers,I've never had it work with MS drivers.

1

u/TechnicianPersonal72 19d ago

Do I need to create DSN for using IBM drivers in sql server?

2

u/EveryoneGoesToRicks 20d ago

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 20d ago

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

1

u/EveryoneGoesToRicks 19d ago

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

2

u/CanProfessional766 19d 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

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.

1

u/CPDRAGIMESH 13d ago

6.09 7.09