What is the source? What is the destination?

It really is the case. If you want to use it in SQL Server 2012 environment, you need to upgrade the package first.

Normally SSIS does this for you, so I...

Don't be nervous. Just...

Thanks for the question.

For the test data you provided, the last line is not necessary. I added it as an extra check.

Say for example project 1425 has a third line with demo_code DE2,...

Very interesting question, thanks!

Great question Tom, thanks!

That would be a left input join. (similar to a left outer join in TSQL)

You'll have to check for NULL values and use a conditional split.

Did you use the Verbose logging level in the SSIS catalog?

What if you set DelayValidation to true in the package?

It is a...

SELECT *

FROM MyTable WHERE prj_code IN

(

SELECT prj_code

FROM MyTable

WHERE demo_code = 'DE1' and demo_vchar_data = 'U'

INTERSECT

SELECT prj_code

FROM MyTable

WHERE demo_code = 'RAP' and demo_vchar_data = 'YES'

)

AND demo_code IN ('DE1','RAP') AND demo_vchar_data IN...

It supports every feature of enterprise edition. (with the very minimal exception of only 1 client for the distributed replay controller)

Features Supported...

Since it is a test server, can't you use developer edition? Then you can keep your system databases.

Try using the Oracle OLE DB provider. The Microsoft OLE DB provider for Oracle is 32-bit only and is deprecated.

BEGIN and END, your best friends in TSQL 🙂