You work as a database administrator at ABC.com. You have just installed Microsoft SQL Server
Management Studio on one of ABC.com’s workstations and the Microsoft Business Intelligence
Development Studio. You have been requested to design a 12 table transactional package to be
stored on an offsite server’s msdb data store.
You decide that BIDS in this scenario is an overkill and you decide to uninstall it. What utility
should you run to create the requested package?
A.
Use the bulk copy program.
B.
Use the DTS Designer.
C.
Use the Microsoft SQL Server Import and Export Wizard.
D.
Use Process Control Tool.
E.
Use the Package Migration Wizard.
F.
Use the Process Control Tool
G.
Use the ISIS.
Explanation: