Create script task in SSIS

One of the efficient way to extend SSIS control flow is to create  script task. 

Need : We can perform custom task that cannot be performed using default task

Steps involved

1) Select the script task from the toolbox

 



2) Drop the script task to the control flow

 

3) Double click the script task and a window would pop up as shown below. We need to click on the edit script button


4)Look for the section where it specifies //TODO: we need to add our custom code here.

5)