PrepAway - Latest Free Exam Questions & Answers

Which command syntax should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
dtutil /FILE c:\ SSISpackagesXMemberInformation.dtsx /DestServer DBPROD /COPY
SQL; MemberInformation_Prod.dtsx

B.
dtutil /SQL Member-Information /COPY DTS;c:
\SSISpacckages\MemberInformation_Prod

C.
dtutil /FILE c:\SSISpackages\MemberInformation.dtsx /COPY SQL;
MemberInformation_Prod.dtsx

D.
dtutil /FILE c:\SSISpackages\Memberinformation.dtsx /COPY FILE;
W:\ProdSSISpackagea \MemberInformation Prod.dtax


Leave a Reply