PrepAway - Latest Free Exam Questions & Answers

What should you do?

You need to create a package that must meet the following requirements:

It must be transactional. It must be optimized for 20 tables. It must be stored securely in the msdb database of a remote server.

What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Create the package by using DTS Designer.

B.
Create the package by using the Package Migration Wizard.

C.
Create the package by using the Microsoft SQL Server Import and Export Wizard.

D.
On the Microsoft SQL Server 2005 Integration Services (SSIS) menu, click the Create Package submenu.


Leave a Reply