I am trying to insert a row into Table X if that row doesn't exist in Table Y. TO accomplish this, I wrote the following statement in the the sql command in OLEDB transformation:
INSERT INTO X SELECT COL1, COL2, COL3 WHERE PrimaryKey = ?
But the above statement is not parsing. Also, how should i get the logic to only insert rows that don't exist in table Y? PLease advise, thanks in advance.
View Complete Post