You are responsible for the SQL Server 2008 Integration Services (SSIS) instance at your organization. This instance uses SQL Server Authentication. Other developers develop, configure, and deploy packages to the MSDB database. You need to determine whether a package named "DailyLoad" exists in the MSDB database on the local instance of SQL Server. What is the correct dtutil command syntax?

Question

You are responsible for the SQL Server 2008 Integration Services (SSIS) instance at your organization. This instance uses SQL Server Authentication. Other developers develop, configure, and deploy packages to the MSDB database. You need to determine whether a package named "DailyLoad" exists in the MSDB database on the local instance of SQL Server. What is the correct dtutil command syntax?

Accepted Answer

C. dtutil SQL DailyLoad /USERNAME xyz /OSERPASSWORD xxxxxx /EXISTS

Answer

A. dtutil /FILE W:/DailyLoad.dtsx /EXISTS

Answer

B. dtutil /SQL DailyLoad /EXISTS

Answer

D. dtutil /DTS DailyLoad.dtsx /MOVE SQL; destPackage

You are responsible for the SQL Server 2008 Integration Services (SSIS) instance at your organization. This instance uses SQL Server Authentication. Other developers develop, configure, and deploy…

Question

Options

How the community answered

Community Discussion