题目内容
（请给出正确答案）
You are a database administrator in the Los Angeles branch office of a specialty foods sup
The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.
You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.
You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.
You want to enable the server in Sydney to connect to the mainframe. database. What should you do？
A．Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.
B．Modify the workflow in the DTS package so that the server in Sydney is included.
C．On the server in Sydney, install an OLE DB provider for the mainframe. database.
D．On the server in Sydney, delete and then re-create the DTS package.
如搜索结果不匹配，请 联系老师 获取答案
