Choose a Destination
Use this dialog box to specify the destination of the data being 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
Destination
Choose the data-specific driver that matches the data storage format of the destination.
File Name
Specify the path and file name of where the data being imported is to be stored (for example, C:\MyData.xls, \\Sales\Database\Northwind.mdb).
User name
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.
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 to hold the data.
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.
Database
List databases on the specified SQL Server.
Refresh
Cause the database list to populate on Microsoft Windows® 98 computers.