I have an existing SSIS package created on another workstation. It connects to and updates data in a DB2 database. I'm only making one very minor change to the package, so I want to change this package as little as possible.
When I try to open the existing db2 connection manager in the package on my workstation, I get 'The specified provider is not supported. Please choose different provider in connection manager'.
On the properties box, I get the following on the connectionString for the existing connection manager (data source and userid changed to "private"):
Data Source=PRIVATE;User ID=private;Provider=IBMDADB2.DB2COPY1;Persist Security Info=True;
I tried loading the 32 and 64 bit db2 drivers (but I may have done something wrong). I still couldn't get the original db2 connection manager to open, I tried to add a new connection manager, but with it I get the below.
Data Source=PRIVATE;Provider=IBMDADB2 Advanced Page.;
This has 'Provider=IBMDADB2 Advanced Page.;' instead of Provider='IBMDADB2.DB2COPY1', and doesn't let me enter a userid and password, which I need to be able to do.
What am I doing wrong? This is my first experience trying to connect to db2 from SSIS, so any help is appreciated.