Tuesday, 29 November 2011

Conditional split vs Multicast Transformation:

Conditional split Transformation:
It is used to split the data based on the conditions. it contains conditional split default output.
Suppose if we have ‘n’ conditions we will get ‘n+1’ outputs.
We can send single record into single destination only that means the records which are satisfied in first condition those records will not come into the second condition.
Multicast Transformation:
It is used to send the data into multiple destinations and we can’t apply any conditions.
We can send single record into multiple destinations.
If we have ‘n’ inputs we will get  ‘n’ outputs.

SSIS: Creating Package Configurations

This post discusses the creation of Configuration Files and how they can be useful while migrating a package from one environment to an...