You need to ensure that the required information is written to the text file

You implement a SQL Server 2008 Integration Services (SSIS) package.
The package contains the following components:
A data flow task contained in a For Loop container
A Flat File destination component that uses a Flat File connection manager
An OnError event handler
When an error occurs in the package, you plan to write diagnostic information from an
expression that includes the version of the package to a text file.
You need to ensure that the required information is written to the text file.
What should you do?

You implement a SQL Server 2008 Integration Services (SSIS) package.
The package contains the following components:
A data flow task contained in a For Loop container
A Flat File destination component that uses a Flat File connection manager
An OnError event handler
When an error occurs in the package, you plan to write diagnostic information from an
expression that includes the version of the package to a text file.
You need to ensure that the required information is written to the text file.
What should you do?

A.
Use the VersionGUID variable.

B.
Use the ExecutionGUID variable.

C.
Use the SourceID variable.

D.
Use the TaskID variable.



Leave a Reply 0

Your email address will not be published. Required fields are marked *