You work as an Administrator for ABC.com. The company has a SQL Server 2008 computer. The
business model of the company uses SSIS. There are 30 packages that use the same
configuration and are stored in an XML file as a variable.
You want to track the changes that affect a package that uses one variable. You also want to
modify the package to provide automatic notification through email whenever there are changes to
the variable. What should you do?
Each correct answer represents a part of the solution. Choose all that apply.
A.
Set the RaiseChangeEvent property for the variable to true.
B.
Create an OnVariableChanged Event handler.
C.
Set the RaiseChangeEvent property for the variable to false.
D.
Create an OnProgress Event handler.
E.
Add a Send Mail Task to the appropriate event handler.
F.
Create an OnInformation Event handler.