Workaround for Oracle Connectivity Issues with SSIS on X64

We initially faced lot of problems connecting to oracle while running SSIS when we moved the SSIS Packages from x86 machine into a new x64 bit machine. Thanks Sutha Thiru for his useful blog that helped me solve the problem. So I've compiled them into a few steps how to achieve this.

  1. Install Oracle Client 32-bit and 10.2.0.3 patch in order to support MSDAORA and set the Oracle Home pointing to 32-bit Client installation path.
  2. Deploy the entire Project created in 32-bit machine into a new Project in 64-bit machine. (Save Copy as from the Orignal.
  3. Under Project Properties - > Set Run64bitRuntime to false while running in design mode to succeed.
  4. For Execution of the Package using dtexec utility, Refer to Program files (x86) Path. Change the Environment settings to include this path.
    Note: Once into the (x86) path, Type “dtexec” on the command line to verify it is a 32-bit. This Step becomes a requisite while executing DTS Packages in Backward Compatibility Mode (Using Execute DTS 2000 to embed the Old DTS packages into SSIS).

Comments

Anonymous said…
The following instructions are a slightly different take on how to workaround this challenge:

http://www.artisconsulting.com/Blogs/tabid/94/EntryID/5/Default.aspx
Anonymous said…
Hi,
Thanks for the link. I appreciate your comments

Regards,
Subhash Subramanyam
Anonymous said…
Opulently I agree but I think the post should prepare more info then it has.
Anonymous said…
quite interesting article. I would love to follow you on twitter.

Popular Posts