You are managing a Business Intelligence (BI) infrastructure that uses SQL Server 2008 Integration Services (SSIS). Your infrastructure has many SSIS solutions that contain several packages. The current backup strategy includes nightly backups of all databases on the server. You need to develop a deployment strategy that meets the following requirements:
-Deploys only the packages that have been modified.
-Includes all packages in the current backup strategy.
What should you do?
A.
Use the Package Installation Wizard to deploy packages to SQL Server.
B.
Use the Package Installation Wizard to deploy packages to the file system.
C.
Create a reusable deployment script by using dtutil.exe to deploy packages to the msdb database.
D.
Create a reusable deployment script by using dtutil.exe to deploy packages to the SSIS Package Store.
Explanation:
Tip: "current backup strategy" = "dtutil.exe … msdb"DTUTIL
DTUTIL.exe is another command-line utility; it is used for SSIS package deployment and management. With DTUTIL, developers and administrators can move or copy packages to the msdb database, to the SSIS Package Store (which allows you to further group packages into child folders viewable in SSMS), or to any file system folder. You can also use DTUTIL to encrypt packages, set package passwords, and more. Unlike DTEXEC, DTUTIL has no corresponding graphical utility, unfortunately, but SQL Server Books Online contains a comprehensive reference to the available switches and options.
(Smart Business Intelligence Solutions with Microsoft SQL Server 2008, Copyright 2009 by Kevin Goff and Lynn Langit)