Maybe this?

FROM table1
WHERE (APPLE_IND = 1 OR GRAPES_IND = 1)
OR (SOURCE_ID <> 100 AND ADDRESS <> 'NOT APPLICABLE')

If not, can you try putting your requirement into English?

"Choose...

...smtp codes like we used to do earlier.

Earlier than when? What sort of SMTP codes?

Can you clarify a little?

Was...

I must have explained that issue (opening CSV in Excel rogers the underlying data) more than a thousand times.

Access solves the problem, but how many accountants use Access?

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 6 years, 2 months ago by Phil Parkin.
• This reply was modified 6 years, 2 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...