70-463 · Question #49
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. Custom SSIS task components are .NET assemblies that must be registered in the Global Assembly Cache (GAC) on the target server using gacutil.exe before the SSIS runtime can load them.
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.
- IDeploy the package by using an msi file.
- JAdd a data tap on the output of a component in the package data flow.
How the community answered
(34 responses)- A3% (1)
- D91% (31)
- F3% (1)
- G3% (1)
Why each option
Custom SSIS task components are .NET assemblies that must be registered in the Global Assembly Cache (GAC) on the target server using gacutil.exe before the SSIS runtime can load them.
dtexec /rep /conn executes a package and reports status to a SQL Server connection; it does not install or register custom component assemblies.
Creating a reusable custom logging component addresses logging architecture and is unrelated to deploying an existing custom task component.
An OnError event handler manages runtime error responses within a package and does not install custom task assemblies on a target server.
The gacutil.exe tool registers a .NET assembly in the GAC, which is required for the SSIS runtime on the target server to discover and instantiate the custom task component - without this step the package will fail to load the custom task at runtime regardless of how the package itself is deployed.
dtutil /copy moves individual package files between storage locations but does not register custom component assemblies in the GAC.
Deploying a package to the SSIS catalog via dtutil makes the package available for execution but does not install the custom task assembly on the target server.
dtexec /dumperror /conn runs a package and generates diagnostic dump files on error; it does not deploy or register custom task components.
The Project Deployment Wizard deploys the .ispac project file to SSISDB but does not register custom component assemblies in the GAC on the target machine.
Deploying via an MSI file can install software but is not the standard mechanism for registering custom SSIS task assemblies in the GAC for SSIS runtime discovery.
A data tap captures data flowing through a data flow component for debugging purposes and has no relationship to deploying custom task components.
Concept tested: Deploying custom SSIS components via Global Assembly Cache
Source: https://learn.microsoft.com/en-us/sql/integration-services/extending-packages-custom-objects/building-deploying-and-debugging-custom-objects
Topics
Community Discussion
No community discussion yet for this question.