Hello Everyone

Thanks for showing your interest to help me for this problem. Even though I could not resolve this problem, I got workaround for this issue.

Instead of calling DTEXec command,...

• This reply was modified 4 years, 4 months ago by  sarang1183.
• This reply was modified 4 years, 4 months ago by  sarang1183.

Thanks Wayne for this reply. I will check this and let you know...

Hi Fredrico

Thanks for your time to respond to my post. Oracle client is already installed on Server.

Question, When  i run DTEXEC command from my workstation, which oracle client is used...

a) You said that you can execute (not deploy) the package from SSDT, correct? I said that I can execute the package as well as deploy it from my local...

Hi Phil

I have already tried that option . But it did not help. I still keep getting same Oracle connection error.

I did the change you suggested, compiled/ deployed the package...

When you say SQL Server Instance, what does it mean ? SQL Server instance having SSIS DB catalog installed on it (where packages are deployed ) OR just SQL Server...

Hi Phil

Yes. On my current workstation, I have installed SSMS 2016 (Sql Server Management Studio, free download) and SSDT 2015 (free download). As per my understanding, DTExec becomes available in...

Hi Phil

SSIS DB catalog + database (tables stored proc) are on different Server from my workstation. MY workstation only has SSDT 2015 and SSMS 2016.

To answer your question,"Regarding this comment,...

Hi Phil

There is no DTExec under Program files. Also I dont have any folder such as "C:\Program Files\Microsoft SQL Server\140\DTS\Binn".

I read somewhere that if you install SSDT 2015 on 64...

Hi Phil

Thanks for your response. but how to download SSDT 2015 64 bit version ? I searched everywhere, its not available.

Can you please provide link, if you are aware ?

Hi All

Thanks a lot for your constructive replies and patience to hear my problem....I got the solution to this problem.. off course I had to change my...

GilaMonster

Thanks for your valuable feedback..

I...

Hi Chris

Thanks for showing interest to  understand the query. But unfortunately being SOX audited application, I am not allowed to share any potion of my code / query.

Hi Guys
First of all, I really appreciate your responses and suggesitons... thanks for that...

I checked with my DBA and asked him all the options you suggested. As per him,...