SSIS::::Using Conditional Split Transformation

Introduction

   Create a New Project with the name as ExpressionLanguageDemo.Once the project is created, open Solution Explorer and rename Package.dtsx - change the name to ConditionalSplit.dtsx. If you've already created the project, right-click the SSIS Packages folder in Solution Explorer and

Video:: Using the CheckSum Function in SSMS

I found this video with Very simple Explanation about Check Sum Function.

Watch it once to know Check Sum Function Usage  n Output Results in SSMS.

http://www.sqlservercentral.com/articles/Video/65068/

SSIS::::Solved BUG of Aggregation Transformation

         One day I was strucked with a bug when I am practicing Aggregate Transformation. After a day of frustration I searched for solution which rescue me. I think that every SSIS developer (and maybe every developer) can learn a thing or two from their mistakes.

SSIS::::Using Audit Transformation

About Audit Transformation::

    The Audit Transformation is a simple component that simply adds the values of certain System Variables as new columns as you name to the data flow. It looks like as below:

SSIS::::Using Aggregate Transformation

About Aggregate Transformation:

The Aggregate Transformation provides a means of carrying out some simple aggregations on data selected through source.Available aggregation functions in this transformation are: