nerdexam
Microsoft

70-448 · Question #220

You maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare supply chain data management company. Your company uses a third-party event based scheduler. You develop a…

The correct answer is D. dtutil /FILE c:\SSISpackages\Memberinformation.dtsx /COPY FILE. See the full explanation below for the reasoning.

Question

You maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare supply chain data management company. Your company uses a third-party event based scheduler. You develop a package named Memberinformation.dtsx and save it in the SSISpackages folder on the company network. You need to deploy this package to the ProdSSISpackages file system on the production server. You need to rename the package to Memberinformation_Prod.dtsx, and the event based scheduler will execute the renamed package. Which command syntax should you use?

Options

  • Adtutil /FILE c:\ SSISpackagesXMemberInformation.dtsx /DestServer DBPROD /COPY SQL;
  • Bdtutil /SQL Member-Information /COPY DTS;c:
  • Cdtutil /FILE c:\SSISpackages\MemberInformation.dtsx /COPY SQL; MemberInformation_Prod.dtsx
  • Ddtutil /FILE c:\SSISpackages\Memberinformation.dtsx /COPY FILE;

How the community answered

(35 responses)
  • A
    9% (3)
  • B
    6% (2)
  • C
    3% (1)
  • D
    83% (29)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice