New Information - SQL Server 2000 SP3.
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.
Name a new connection to a data source.
Select an existing connection to a 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.
Specify the database path and file name holding the data to be imported (for example, C:\MyData.xls, \\Sales\Database\Northwind.mdb).
Specify a user name for the database connection.
Specify a password for the database connection.
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
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.
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.
Specify the name of the existing user or system data source name (DSN) that points to the data source.
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.
Specify the name of the existing file DSN that points to the data source.
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.
Security Note When possible, use Windows Authentication.
List databases on the specified instance of SQL Server.
Cause the database list to populate on Microsoft Windows® 98 computers.
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.