Connection Properties

DTS Designer

DTS Designer Help

Connection Properties

Use this dialog box to add a connection to a data source, which can be either a new connection or a copy of an existing connection. Not all of the following options are available for all providers. A subset of the options will be available, depending on the provider selected.

Options

New connection

Name a new connection to a data source.

Existing connection

Select an existing connection to a data source.

Data source

Select an OLE DB provider from the list of available providers. By default, the Microsoft® OLE DB Provider for SQL Server is selected. If your data source or data destination is an instance of Microsoft SQL Server™, it is recommended that you use this provider, because it offers options such as high-performance bulk loading of data and setting batch size when copying and transforming 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.

UDL Filename

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

Always read properties from UDL file

Specify that the package resolve information in the data link (.udl) file at run time. 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. 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 to create an ODBC DSN. For more information about creating an 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 an instance of SQL Server.

Use SQL Server Authentication

Specify that the package use SQL Server Authentication for login to an instance of SQL Server.

Database

List databases on the specified instance of SQL Server.

Refresh

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

Advanced

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

See Also

DTS Connections

Data Link Connection

Transform Data Task