Your workstation has installed Microsoft SQL Server Management Studio (SSMS), and not
installed Microsoft Business Intelligence Development Studio (BIDS).
You should design a package, which has the following features:
The package should be transactional.
The package should be optimized for 10 tables.
The package should be stored safely in the msdb database of a server which is remote.
Which is correct?
A.
You should create the package by using DTS Designer.
B.
You should create the package by using the Package Migration Wizard.
C.
You should create the package by using the Microsoft SQL Server Import and Export
Wizard.
D.
On the Microsoft SQL Server 2005 Integration Services (SSIS) menu, You should click
the Create Package submenu.