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...

OK, let's backtrack a little.

You can run the package from SSDT and it works fine.

In SSDT, try going to Project/Properties/Configuration Properties/Debugging and setting Run64BitRuntime to false.

Run the...

Perhaps something like this would help you?

https://www.mssqltips.com/sqlservertip/2167/custom-spstartjob-to-delay-next-task-until-sql-agent-job-has-completed/

The fact that DTExec gets installed by SSDT does not necessarily mean that it will run from the command line.

If you run the DTExec which is on the SQL Server...

To be honest, I'm running out of ideas, so I decided to go back to basics.

You are saying that you can run packages from the command line using the DTExec...

This package runs fine with SQLAGent job as well. But I want to make this package working only with DTExec command, since I have some dependencies.

Regarding this comment, is this...

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...

Is that Oracle provider a 64-bit piece of software?

Because it looks like you are calling the 32-bit version of DTExec.

Try making the same call, but with the 64-bit version.

It's actually not a reserved SQL Server keyword.  [It is reserved in ODBC, but that's...

It isn't unusual -...

• This reply was modified 5 years, 5 months ago by Phil Parkin.
• This reply was modified 5 years, 5 months ago by Phil Parkin.

It's going to be difficult to suggest modifications to such a complex piece of SQL without having some DDL and sample data to test it on.

Some comments:

1. Tables should be...

Based on the example data provided, what output are you hoping for?

You don't need to include the brackets or commas in the subquery – you only need it to return the values you're comparing against.

Select ...
Where x in (select...

Which 'following table' and which 'connection string details'? Why are you avoiding providing more information? Also, where is the DDL for the temp table you want to...

I have the following table ...

Where is this 'following table'?

If you are just selecting from table1 all the time, why not select all of the rows you need in one...