I'm looking for some clarification.
We need to pull data from our DB2 system to our Itanium SQL Server.
Is this simply a matter of setting up the 64-bit DB2 Connect drivers on the Itanium box with the exact same DSN name used on ther 32-bit box used to define and deploy the SSIS package
Has any one done this, yet If so, is there anything that we need to look our for
Thanks,
- Paul
Setting up connection from DB2 to Itanium
garfield1969
Paul
If it's ok for you to use remote connection at dest, you can stay in the 32bit box and remote connect your dest to the Itanium server. That way, the least modification is needed. Plus, considering the fact SSIS designer is not supported on ia64box yet, to take advantage of SSIS designer features, you are better off just using your 32bit box to accomplish the transfer job.
If for some reason, you prefer to use local connection to your Itanium server, you'll have to move the pkg and run it locally on the Itanium server. There are 2 options here: to run it on native 64bit or in WOW (use 32 binaries on a 64bit box).For the native 64bit choice,you do need to setup the DB2 ia64 provider; For the WOW choice, nothing should need to be changed as far as I can see.
wenyang