July 15, 2008 at 9:35 am
I am trying to create a SSIS package that is going to compare two lists. The first list is of all employees. Fields include employee id, office location, name, email, office phone, home phone, cell phone. The first list acts as the master list, employee id being the primary key. The second list would be a compare to the first list to find any changes, i.e. name change, cell phone number change.
I want to email a Excel spreadsheet with the changes to our publisher along with an updated master list once the compare is done.
For example,
First List
00001 Joe Smith 123-456-7890
00002 Kim Jones 616-525-4334
Second List
00001 Joe Smith 123-456-7890
00002 Kim Knack 616-525-4334
00003 Bob Bright 291-534-8483
Email Changes and Updated Master List (Second List) in Excel spreadsheet
Changes
00002 Kim Knack 616-525-4334 Name Changes - (Old = Kim Jones)
00003 Bob Bright 291-534-8483 New Record
Updated Master
00001 Joe Smith 123-456-7890
00002 Kim Knack 616-525-4334
00003 Bob Bright 291-534-8483
I'm not sure I explained this well enough, but I am looking for some ideas as to how to do this.
Thanks!
July 15, 2008 at 12:53 pm
At http://www.sqlbi.com/%5B/url%5D you can download a TableDifference component for free. It is essentially a MERGE JOIN and a Conditional Split in a single component. It will allow you to pretty easily compare two data flows (they must be sorted first) and output data flows for added, deleted, and changed rows.
You could also do this same thing with a MERGE JOIN and a Conditional Split, but this control make make it easier for you.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply