You work as a database administrator at ABC.com. ABC.com is making use of SQL Server 2008
R2.
You have just installed SQL Server Management Studio (SSMS) on one of ABC.com’s
workstations. You have not, however, included the Business Intelligence Development Studio
(BIDS) in the installation.
You are then instructed to design a transactional package that has the ability to accommodate
using in excess of 8 tables, and is hosted by the msdb database of a server that is located in a
different location.
Which of the following actions should you take?
A.
You should consider making use of the dtexec utility.
B.
You should consider making use of the bulk copy program.
C.
You should consider making use of the dta utility.
D.
You should consider making use of the SQL Server Import and Export Wizard to create the
package.
Explanation: