How to delete rows based on comparison from Data Flow Task in an SSIS?
- by vikasde
I have a DataFlow task with two OLE DB Source objects. This is the SQL I want to achieve using SSIS:
Insert into server2.db.dbo.[table2] (...)
Select col1, col2, col3 ...
from Server1.db.dbo.[table1] where [table1.col1] not in
(Select col5 from server2.db.dbo.[table2] Where ...)
I am pretty new to SSIS and not sure how to achieve this. I thought I could do this using the Data Flow task and populating the first source with the data from server1.db.dbo.table1 and the second source with server2.db.dbo.[table2] and then do the conditional check before inserting it into server2.db.dbo.[table2]. I am not sure how to do the conditional check though. Any help is appreciated.
