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.
Choose the data-specific driver that matches the data storage format of the source 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.
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.
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.
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.
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, 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.
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 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.
List databases on the specified instance of SQL Server.
Cause the database list to populate on Microsoft Windows® 98 computers.