SSIS Tutorial – Script Task Vs Script Component

Another SSIS Tutorial brought to you by BeardedDev.

In this video we take a look at the Script Task and Script Component, we know that Integration Services is a great ETL Tool but sometimes we have to work outside the scope of SSIS and thanks to the .Net Framework the Script Task and Script Component extend the capabilities of Integration Services.

This tutorial takes a look at the differences between the Script Task and Script Component and when to use them.

The Script Task is part of the control flow and the Script Component is part of the data flow and must be set as a source, transformation or destination in SSIS.

We are able to write code in Visual C# or Visual Basic and refer to or set variables within the script.