SSIS Interview Question:

Can we add our custom code in SSIS?

Submitted by: Administrator

We can customize SSIS through code by using Script Task. The main purpose of this task is to control the flow of the package. This is very useful in the scenario where the functionality you want to implement is not available in existing control flow item.

To add your own code:-

1. In control flow tab, drag and drop Script Task from toolbox.
2. Double click on script task to open and select edit to open Script task editor.
3. In script task editor, there are 3 main properties
i.) General - Here you can specify name and description
ii.) Script - through this we can add our code by clicking on Design Script button. The scripting language present is VB.Net only.
iii.) Expression
Submitted by: Administrator