November 8, 2007 at 10:20 am
I have a SSIS task from one SQL server production system to a SQL Server Reporting System. I wish to set up a package so that if the Prime Keys are equal the row will be updated if not the row should be appended.
How do I achieve this?
If I create a package with OLE DB source and SQL Server destination on a Data Flow task, what happens by default if the source contains a row that is equal to a row currently on the destination comparing Prime Keys?
Any help would be appreciated
Regards
David Halliday
November 8, 2007 at 12:02 pm
November 9, 2007 at 4:50 am
Tommy
Thank you very much. That was exactly what I was looking for
Regards
David
November 9, 2007 at 9:13 am
NP 😀
Tommy
Follow @sqlscribeViewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply