I've been reading on SSIS for a couple of days now, and haven't come across a
mechanism on updating existing data!
My data source is a delimited flat file which i'll have to validate and then
plug into SQL server 2005.
But its possible that the records already exist, in which case i'll need to
udpate the existing records, else add them.

So, is it possible to update existing records using the existing SSIS tools?
Or would i have to script this?

One way to do it would be to have SSIS toss your flat file into a
temporary staging table in SQL server. Then run a sql statement to
insert records into your live table where they don't already exist, and
update all records that do exist.


Luke wrote: