nerdexam
Microsoft

70-458 · Question #101

You are deploying a new SQL Server Integration Services (SSIS) project to the test environment. A package in the project uses a custom task component. You need to ensure that the custom object is…

The correct answer is D. Use the gacutil command. See the full explanation below for the reasoning.

Question

You are deploying a new SQL Server Integration Services (SSIS) project to the test environment. A package in the project uses a custom task component. You need to ensure that the custom object is deployed on the test environment correctly. What should you do?

Options

  • ARun the package by using the dtexec /rep /conn command.
  • BCreate a reusable custom logging component.
  • CCreate an OnError event handler.
  • DUse the gacutil command
  • EUse the dtutil /copy command.
  • FDeploy the package to the Integration Services catalog by using dtutil and use SQL Server to
  • GRun the package by using the dtexec /dumperror /conn command.
  • HUse the Project Deployment Wizard.
  • JAdd a data tap on the output of a component in the package data flow.

How the community answered

(52 responses)
  • B
    6% (3)
  • C
    2% (1)
  • D
    79% (41)
  • E
    10% (5)
  • F
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 70-458 Practice