April 15, 2009 at 4:33 pm
I have 2 sets of identically structured data that I join on key fields using a merge join.
I want to verify if any data is different between the 2 sets.
1 set of data comes from SQL the other from a sharepoint list. I am currently using a conditional split and check every field for differences, but I am now dealing with some NULLs that is causing problems with the compare and the statement is getting ridiculously long and very difficult to maintain.
I have many other places where a new technique would be useful.
Doesn't SSIS have an equivalent to CHECKSUM?
I can't dump the destination table and reload since it is referenced by FK's
Does anyone have any technique to accomplish this more quickly that is also easily maintainable?
April 16, 2009 at 10:44 am
You can apply CHECKSUM(AllColumnsSepBycommas) in your SELECT in the Data Flow Task Sources (on both sources of merge join).
[ps - u can automate this from the metadata]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply