nerdexam
Microsoft

70-448 · Question #281

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…

The correct answer is A. Use the VersionGUID variable. See the full explanation below for the reasoning.

Question

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?

Options

  • AUse the VersionGUID variable.
  • BUse the ExecutionGUID variable.
  • CUse the SourceID variable.
  • DUse the TaskID variable.

How the community answered

(50 responses)
  • A
    72% (36)
  • B
    4% (2)
  • C
    8% (4)
  • D
    16% (8)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice