Compare 2 Columns using SSIS from two different tables RRS feed

  • Question

  • Hello,

    A newbie to ssis.

    I have a Table 1 with Address Details and Table 2 with Address Details of same customer but from different sources. I have loaded these two data sources and also joined these two tables.

    I want to compare address column of one table with the other table, if they are not equal need to insert into another table.

    With Sql query we can perform it, but just want to know how to perform this with ssis.

    Wednesday, March 4, 2015 8:03 PM