This content has been marked as final. Show 2 replies
The component you are calling may not be 64-bit (and I believe DTS exist as both 32 and 64-bit executable). If it is 32-bit, thus needing 32-bit libraries, it may explain "execute failure".1 person found this helpful
I tried the suggestion provided by you. It gives an error while connection establishment. If I use the 64 bit DTexec utility to execute the same package it connects but throws an internal data conversion error. I even tried to run the package through Execute package utility in SQL Server it is also not working. The same package runs perfectly fine in the development server having 32 bit Oracle Client.