Upserting

“Upserting is when you insert a row if it doesn’t exist or update it if itdoes.” Kirk Haselden, Microsoft SQL Server 2005 Integration Services

http://en.wikipedia.org/wiki/Upsert

The SSIS “Slowly Changing Dimensions” is kind of a upsert process. But, it is very slow. The following link provide a better solution. (Slowly Changing Dimensions is more then upsert.)

http://blog.stevienova.com/2008/11/22/ssis-slowly-changing-dimensions-with-checksum/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s