New answers tagged ssis
I'd try two things: 1) make sure you set a windows system environment variable: TNS_ADMIN pointing to your TNS names file(restart sql server agent required) 2) look at your PATH and make sure the x64 client comes before the x32 client 3) if all else fails forgo the tns names files and use EZCONNECT
Not unless you run the package from the gui... if you just want to get exectuion progress you could add some logging to your package execution: Implementing Logging in Packages
I had this same issue. After some research and convincing the server I didn't have control over to add a Windows Authenticated account to there location and some insight from the below URL, I got it working: ...
Top 50 recent answers are included