Connection Properties
Use this dialog box to specify a connection (session) and optionally, a database (catalog) for importing meta data, if supported by the data provider. These specifications must be made to import meta data (for example, table and column information, primary and foreign keys, indexes) into Microsoft® SQL Server™ 2000 Meta Data Services. For the import of meta data to work, the data provider specified must support OLE DB schema rowsets.
After a connection is made, Data Transformation Services (DTS) reads the meta data information from the specified connection into Meta Data Services. Later, when you save a Data Transformation Services (DTS) package with Scanning Options enabled, the tasks in the package will form relationships to the imported meta data.
With the Import Metadata selection you read the meta data from only one database (catalog); when you select Scan all referenced catalogs in the Scanning Options dialog box, the meta data from all databases referenced in the package are saved to Meta Data Services.
Not all the options defined below are available for all providers. A subset of the options will be shown, depending on the provider chosen.
Options
Source
Select the data-specific driver that matches the data storage format of the source data.
File Name
Specify the database path and file name holding the data to be imported (for example, C:\MyData.xls, or \\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 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 Microsoft Data Link (.udl) file that contains the connection string.
Always read properties from UDL file
Specify 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 DTS package directly.
Properties
Display the Data Link Properties dialog box, where you configure a 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 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 the SQL Server database.
Use SQL Server Authentication
Specify that the package use SQL Server Authentication for login to the SQL Server database.
Database
List databases on the specified instance of SQL Server.
Refresh
Cause the database list to populate on computers running on Microsoft Windows® 98.