Create a stored procedure to do the merging. The stored procedure would contain code like this:INSERT INTO TableB
(col1, col2)
SELECT
col1,col2
FROM
TableA a
WHERE NOT EXISTS
(
SELECT * FROM TableB b
WHERE b.col1 = a.col1 AND b.col2 = a.col2
);
Then, create an Execute SQL Task in SSIS and have it call that stored procedure.
Compare two tables in ssis
Posted - 12/05/2012 : 13:25:13
