I want to design a SSIS package with following requirements:
Below are the 3 queries
1 SELECT * FROM EMP WHERE EMPNAME='TEST'
2 SELECT * FROM EMP WHERE ENO=200
3 SELECT * FROM EMP WHERE EADDRESS='ATLANTA'
The trick is I need to run query 2 which should not include the output from query 1
and query 3 shouldnt return the rows shown in Query 2.
How is it possible in SSIS?