You work as a database administrator at Domain.com. You have completed the installed
Microsoft SQL Server Management Studio (SSMS) on one of Domain.com’s workstations but not
the Microsoft Business Intelligence Development Studio (BIDS). However, you need to design a
package with the following characteristics:
* The package should be transactional.
* The package can use 10 tables.
* The package should be stored in the msdb database of a server which is remote.
What should you do?
A.
You should consider using the Package Migration Wizard to create the package.
B.
You should consider using the DTS Designer to create the package.
C.
You should consider using the Create Package submenu to create the package.
D.
You should consider using the Microsoft SQL Server Import and Export Wizard to create the package.