You work as a database administrator at Domain.com. You have just 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:
* It must be transactional.
* It must be able to accommodate the use of 10 tables.
* It must be stored in the msdb database of server that is offsite.
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.