November 6, 2007 at 9:43 pm
The SSIS package should be able to check if incoming rows already exist previously, perform updates if there were changes on any columns, and insert a new row if data does not exist.Source files coming in would have fields in comma delimitered format.The final destination would be a table with updated rows from all 3 source files.
I'm not sure why people go through such pains as the "merge" you describe... you're loading the data to a staging table... immediate contents of the staging table don't matter... they can contain dupes or whatever... load all 3 files without regard to dupes... when you're done loading just delete the dupes. Much faster than writing all that "merge" code.
And wait for the last file to materialize before you do any importing.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy