Dts.Events.FireInformation method in Script task in SSIS

When we are working with the script task some time we need to know the progress information. For getting the information we can use MessageBox.show () Method but the thing is that once a message is pop up then we need to manual intervene then it will go for next.

For overcoming this issue we can use the Event method to fire information method.

Let’s see the example

Syntax:

Dts.Events.FireInformation (int value, "Script Task Name ","Internet connection detected.” String. Empty, 0, fire Again ( bool value))

Taking the script task

In the script task I am writing the code

bool fireAgain = true;             for (int i = 1; i <= 10; i++)             {                 Dts.Events.FireInformation(0, "Fire Information", "Count : " + i.ToString(), string.Empty, 0, ref fireAgain);             }

 It will fire the information.

Now running this package.

Package is executed successfully.

See the execution log.