Export (0) Print
Expand All

Choose a Data Source

SQL Server 2000

Choose a Data Source

  New Information - SQL Server 2000 SP3.

Use this dialog box to specify the source of the data to be copied. Not all the options defined below are available for all providers. A subset of the options below will be shown, depending on the provider chosen.

Options

Data Source

Choose the data-specific driver that matches the data storage format of the source data.

File Name

Specify the database path and file name holding the data to be imported (for example, C:\MyData.xls, \\Sales\Database\Northwind.mdb).

Username

Specify a user name for the database connection.

Password

Specify a password for the database connection.

Advanced

Display the Advanced Properties dialog box, where you can enter custom settings. For more information about the OLE DB provider properties, search in the Platform SDK section in the MSDN® Library at Microsoft Web site.

UDL Filename

Specify the name of the data link (.udl) file that contains the connection string. 

Security Note  UDL files are not encrypted and you therefore need to secure the folder in which they reside.

Always read properties from UDL file

Request that the package search for and read the connection string from the specified data link (.udl) file each time the package is executed. Changes made to the data link file between different executions of the package will be incorporated on the next run. If you select this check box, the .udl file must be deployed with the package so the package can find it and read from it. If you do not select this check box, the connection string is copied from the .udl into the package, and the file is not referenced again. Connection changes then can be modified only by editing the Data Transformation Services (DTS) package directly.

Properties

Display the Data Link Properties dialog box, where you configure the data link connection. Changes made in the dialog box will be incorporated into the package created during the current session and will not change the data link file.

User/System DSN

Specify the name of the existing user or system data source name (DSN) that points to the data source.

New

Display the Create New Data Source dialog box, where you can create an ODBC DSN. For more information about creating a new ODBC data source, search in the Platform SDK section in the MSDN Library at Microsoft Web site.

File DSN

Specify the name of the existing file DSN that points to the data source.

Server

Specify the name of the server holding the data source.

Use Windows Authentication

Specify that the package use Windows Authentication for login to the Microsoft® SQL Server™ database.

Use SQL Server Authentication

Specify that the package use SQL Server Authentication for login to the Microsoft SQL Server database.

Security Note  When possible, use Windows Authentication.

Database

List databases on the specified instance of SQL Server.

Refresh

Cause the database list to populate on Microsoft Windows® 98 computers.

See Also

DTS Connections

Show:
© 2014 Microsoft