It worked thanks a ton....

uday

I tried using the Slowly Changing Dimension transormation. I basically need two paths - One to insert the new record ('New Output Path' to OLE DB Destination) and one to...

I'm not handling such large data. But will be mindful of that... thanks for the warning.

Oh cool! I should have thought of that before... thanks a lot :o)

My question was not how do it in the DB directly. Im trying to figure out if there is a way in Sql Server Integration Services (DTS) to do the...

Ok.... i havent the slightest idea what that meant!

Hi,

I urgently need to know how to carry out an UPSERT in SSIS 2005. If anyone knows the way to do it, please let me know as soon as possible.

TIA,

Uday.