Sunday, 30 June 2013

SSIS Conditional Transform Tasks


Conditional Transform Task is used to split the data according to the condition and save the data into different destination. In this article we are going to discuss about the Conditional Transform Task.

Case Study
We have a flat file named EmployeeDeatils.txt. The flat file contains EmployeeID, Employee Name and Country of Origin. Depends on the country of Origin it segregate the records into two different texts file named EmployeeofUS.txt and EmployeeofINDIA.txt.

How to Configure the Conditional Transform

Step-1 [ Source Flat File ]

Step-2 [ SSIS Data flow Task ]

Step-3 [ Flat file source editor configuration ]

Step-4 [ Conditional Split Transformation Editor Configuration ]

Step-5 [ Flat File Destination Editor Configuration ]

Step-6 [ Run the SSIS Package ]

Step-7 [ Analyzing the Output of the SSIS Package ]

Hope you like it.

Posted by: MR. JOYDEEP DAS

No comments:

Post a Comment