nerdexam
Microsoft

70-448 · Question #86

You are creating a SQL Server 2008 Integration Services (SSIS) instance which includes components listed below for Company.com. A String variable called FileTestName. A String variable called…

The correct answer is B. You should configure the EvaluateAsExpression attribute of the User::DirectoryPath parameter to True. D. You should configure the Expression property of the User::DirectoryPath parameter to the following. See the full explanation below for the reasoning.

Question

You are creating a SQL Server 2008 Integration Services (SSIS) instance which includes components listed below for Company.com. A String variable called FileTestName. A String variable called DirectoryTestPath. A Foreach Loop container for the Collection property is listed below:

A Foreach Loop container for the Variable Mappings property is listed below:

In order to update the package so that the DirectoryTestPath variable gets the directory path for the file path reserved in the FileTestName variable. Which is the correct answer? (Select two)

Exhibits

70-448 question #86 exhibit 1
70-448 question #86 exhibit 2

Options

  • AYou should configure the EvaluateAsExpression attribute of the User::DirectoryPath parameter to False.
  • BYou should configure the EvaluateAsExpression attribute of the User::DirectoryPath parameter to True.
  • CYou should increase a Script job to the OnPostExecute event handler of the Foreach Loop container.
  • DYou should configure the Expression property of the User::DirectoryPath parameter to the following
  • EYou should configure the Expression property of the User::DirectoryPath parameter to the following

How the community answered

(43 responses)
  • A
    9% (4)
  • B
    77% (33)
  • C
    12% (5)
  • E
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice