Last post May 02, 2012 03:34 AM by santoo012
May 02, 2012 03:34 AM|santoo012|LINK
I have two tables A ( Id, Value ) and B (Id, Value ) in different Databases.
I want to create a SSIS package which will compare both tables A and B for some specified Id values got from some condition.
and look if for each Id value if Value in A matches to Value in B, if not write it to a file.
Hoe can i do this.