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.