Monthly Archives: June 2011

Get N sample rows from a huge dataset

Posted on June 25, 2011 by

In my previous article I have discussed about Percentage Sampling Task. But, there is one one task similar to that in Integration Services. This task fetches only N sample rows from the given dataset. Row Sampling Transformation Row Sampling task can be … Continue reading →

Posted in SSIS | Tagged , , | Leave a comment

Fetch sample dataset from a huge dataset

Posted on June 24, 2011 by

Dataset is a collection of data. We may have huge volume of data related to any business, research output, statistics and etc. But, experiments need a sample data to validate the business logic or algorithm. Percentage Sampling Transformation Percentage Sampling Transformation fetches … Continue reading →

Posted in SSIS | Tagged , , , , | Leave a comment

Row Counter

Posted on June 23, 2011 by

SSIS developers often need to audit the tables to check number of records transferred from source to destination. It is very easy if you use SSIS. Row Count Transformation  It gives us the row count value during data transformation. This task … Continue reading →

Posted in SSIS | Tagged , , | Leave a comment

Create a duplicate column during data flow

Posted on June 22, 2011 by

We may need to create a duplicate copy of a column in the data flow. There are various way to achieve this. But, SSIS gives us a simple way to make a copy of a column during the data flow. … Continue reading →

Posted in SSIS | Tagged , , , | Leave a comment

Character Map Transformation

Posted on June 21, 2011 by

It is a very simple column transformation task which performs string conversions like lower case to upper case, etc. There are other operations available for this task. In this article, I will be showing you, how to use this task … Continue reading →

Posted in SSIS | Tagged , , | 1 Comment