Administering SSIS packages

Posted on
Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone

Questions derived from the 70-445 – TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance Microsoft Self-Test Software Practice Test.

 

Objective: Administering SSIS packages
SubObjective: Manage SSIS package execution

 

Item Number: 70-445.10.3.1
Single Answer, Multiple Choice

 

You are a database administrator for your company. The developers of your company have developed a package named DataFilter. The testing team has tested the package. You need to move the DataFilter package on to the QAServer server. You want to overwrite the package if it already exists on the QAServer server.

 

Which syntax should you use to move the package to the QAServer server?

 

 

  1. dtutil.exe /File DataFilter.dtsx /Copy SQL;QAServer;DataFilter /I /Quiet
  2. dtutil.exe /S QAServer /E /N DataFilter /F DataFilter.dtsx
  3. dtutil.exe /DestS QAServer /File DataFilter.dtsx /Copy SQL;DataFilter /Quiet
  4. dtutil.exe /DestS QAServer /Copy DataFilter.dtsx SQL;DataFilter /I /Quiet

 

Answer:
C. dtutil.exe /DestS QAServer /File DataFilter.dtsx /Copy SQL;DataFilter /Quiet

 

Tutorial:
You should use the following syntax to move the package to the QAServer server:

 

dtutil.exe /DestS QAServer /File DataFilter.dtsx /Copy SQL;DataFilter /Quiet

 

The dtutil.exe utility is used to manage SQL Server 2005 Integration Services (SSIS) packages. You can move, copy, and delete packages by using the dtutil.exe utility. The dtutil.exe utility uses the following syntax to copy the package from one server to another:

 

dtutil /option [value] [/option [value]]

 

In the given syntax:

 

 

  • /DestS option specifies the server name.
  • /File option specifies the file name.
  • /Copy option specifies the location of the package, the SQL option is used when destination location is SQL.
  • /Quiet option is used when you do not want any prompt for confirmation.

 

In this scenario, the /Quiet option will overwrite any existing package without any prompt confirmation.

 

You should not use the following syntax to move the package on the QAServer server:

 

dtutil.exe /DestS QAServer /Copy DataFilter.dtsx SQL;DataFilter /I /Quiet

 

In this command, the package name is specified with the /File option and, therefore, is syntactically incorrect.

 

You should not use the following syntax to move the package on the QAServer server:

 

dtutil.exe /File DataFilter.dtsx /Copy SQL;QAServer;DataFilter /I /Quiet

 

In this command, the destination server name is not specified under /DestS option. The destination server name must be specified under the /DestS option to move the package successfully to the destination server. Therefore, this option is incorrect.

 

You should not use the following syntax to move the package on the QAServer server:

 

dtutil.exe /S QAServer /E /N DataFilter /F DataFilter.dtsx

 

This command specifies invalid options for the dtutil.exe utility.

 

Reference:
http://msdn2.microsoft.com/en-us/library/ms162820.aspx

Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone
cmadmin

ABOUT THE AUTHOR

Posted in Archive|

Comment: