What is the correct dtutil command syntax?

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?

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?

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

B.
dtutil /SQL DailyLoad /EXISTS

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

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *