Table Difference columns being ignored

347 views
Skip to first unread message

Chris

unread,
Apr 10, 2011, 3:30:21 PM4/10/11
to CozyRoc
Hi,

I seem to be having an issue where all the input columns are being
ignored for the table difference task. Below I included screenshots of
what I see.


http://www.fastuploads.cribs2.net/uploads/SSIS Error 1.png
http://www.fastuploads.cribs2.net/uploads/SSIS Error 2.png
http://www.fastuploads.cribs2.net/uploads/SSIS Error 3.png


Thanks!

Christopher Haws

Ivan Peev

unread,
Apr 10, 2011, 3:46:52 PM4/10/11
to CozyRoc
Hi Christopher,

Your old and new input column names have to match, to see them appear
in the UI. Also make sure the case is exactly the same because the
component is case-sensitive. For the columns you want to use to match
the rows, you have to make sure these columns are sorted and the
component will automatically recognize them as key columns.

Regards,
Ivan
Reply all
Reply to author
Forward
0 new messages