You work as a database administrator at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.
You have received reports regarding a current existing SQL Server Integration Services (SSIS) package not
completing its execution, and not transferring data. You have decided to make use of
the Project Deployment Model.
Which of the following is TRUE with regards to using the Project Deployment Model?
A.
CLR integration is required on the database engine.
B.
CLR integration is not required on the database engine.
C.
Events that are created by the package are captured automatically and saved to the catalog during
execution.
D.
Packages are executed using the dtExec and DTExecUI execution utilities.
Explanation:
A.
CLR integration is required on the database engine.
C.
Events that are created by the package are captured automatically and saved to the catalog during
execution.
Sites of interest we’ve a link to.