You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008.
You work as the technical support. Now you get an order from your company CIO, you are asked to design a SQL Server 2008 Integration Services (SSIS) package.
The package contains an OnError event handler, a data flow task contained in a For Loop container, and a Flat File destination component which uses a Flat File connection manager.
When the package meets an error, from an expression that includes the version of the package, you intend to write diagnostic information to a text file.
You must make sure that you can write the required information to the text file. So what action should you perform?
A.
In order to make sure of this, the SourceID variableshould be used
B.
In order to make sure of this, the TaskID variableshould be used
C.
In order to make sure of this, the VersionGUID variable should be used
D.
In order to make sure of this, the ExecutionGUID variableshould be used.