Home > SSIS Best Practices > SSIS C Sharp #115 – C# Script to detect delta

SSIS C Sharp #115 – C# Script to detect delta

A reader asked me to share a C Sharp script I used in this post, SSIS #114 – How many ways can you do INSERT-UPDATE?.

This code snippet tried to determine if the original value of MyFirstColumn is different or not compared to the incoming data in the pipeline. It is used in the last UPDATE-DELTA design.

image

Notes:

The Script Component needs some configuration. Without the proper configuration, the above code will not work.

Categories: SSIS Best Practices Tags: ,
  1. Jizi
    April 24, 2013 at 3:25 pm

    Hi Sherry, thx for sharing this script! Actually you could call me as big fan haha. I’m a fresh BI developer with 2-year experience since graduation. Now I’m considering to get a Microsoft BI certificate. I understand that people always say that exams are not valuable as experience. Still I believe experience will accumulate by time and exams could accelerate this process. I’m preparing to earn BI certificate and need your advice: which certificate is more widely recognized in this industry? Thank you very much!

    Like

  1. No trackbacks yet.

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

%d bloggers like this: