You are the administrator of several SQL Server 2000 computers. A data Transformation Services (DTS) package uses native OLE DB

admin2009-05-19  26

问题 You are the administrator of several SQL Server 2000 computers. A data Transformation Services (DTS) package uses native OLE DB providers to transfer data between the servers. Connection details for the servers are specified in .udl files. The .udl files are frequently updated as connection details change.

You want to distribute the DTS package as a file to developers in your company. You want to make sure connection details are available to developers who receive the DTS package.

Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two)

选项 A、Enable the Always read properties from UDL file option in the Connection Properties dialog box.
B、Disable the Always read properties from UDL file option in the Connection Properties dialog box.
C、Delete the .udl files and store connection details in the registry by using system data source names.
D、Delete the .udl files, and store connection details in the registry by using user data source names.
E、Make the .udl files available on a network share.

答案A,E

解析 Explanation:
A: To make the connection information available for the developers we must enable the Always read properties from UDL file option.

E: We provide the developers with access to the .udl file by placing the .udl files in a network share and setting appropriate share and NTFS permissions.

Note: In SQL Server 2000, DTS packages can use Microsoft Data Link (.udl) files to create OLE DB connections and resolve the connections in run time. With this feature we can encapsulate the connection properties from a DTS package into a separate file and can edit the connection string in a .udl file instead of the connection properties in a DTS package in situations where connection information such as the server name, login, or even the OLE DB provider may change.

When specifying a data link connection, we must first specify whether to load an existing .udl file or create a data link to save with DTS Designer. If we want to use a .udl file rather than saving the data link with DTS Designer, we can create one either from Windows Explorer or during the data link configuration process in DTS Designer. We must then click Microsoft Data Link in the Data Source list of the Connection Properties dialog box and check the Always read properties from UDL file check box. In this scenario, the .udl file is already specified.

Incorrect Answers:
B: If we clear the Always read properties from UDL file option in the Connection Properties dialog box, we would have to edit the connection properties through the Data Transformation Services (DTS) package. This would increase administrative effort.

C: We cannot delete the .udl files and instead store the connection details in the registry by using system data source names as the connection details change regularly.

D: We cannot delete the .udl files, and instead store connection details in the registry by using user data source names as the connection details change regularly.
转载请注明原文地址:https://kaotiyun.com/show/MuhZ777K
0

最新回复(0)