nerdexam
Microsoft

70-458 · Question #28

You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse hosted on SQL Azure. The package uses a Foreach container to process text files found in a…

The correct answer is C. Environment Variable. See the full explanation below for the reasoning.

Question

You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse hosted on SQL Azure. The package uses a Foreach container to process text files found in a folder. The package must be deployed to a single server by using the Project Deployment model. Multiple SQL Server Agent jobs call the package. Each job is executed on a different schedule. Each job passes a different folder path to the package. You need to configure the package to accept the folder path from each job. Which package configuration should you use?

Options

  • A.dtsConfig file
  • BRegistry Entry
  • CEnvironment Variable
  • DParent Package Variable
  • EXML Configuration File

How the community answered

(57 responses)
  • A
    5% (3)
  • B
    4% (2)
  • C
    77% (44)
  • D
    12% (7)
  • E
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 70-458 Practice