Export (0) Print
Expand All
Expand Minimize

Choose a Destination, Define Transformation of Published Data Wizard

SQL Server 2000

The following options are available on the Choose a Destination page of the Define Transformation of Published Data Wizard.

Options

Destination

Choose the data-specific driver that matches the data storage format of the destination.

Server

Select the name of the server that will receive the transform data.

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). This option is available if Microsoft Jet 4.0 database is selected as the destination.

(. . .)

Click to browse for the Jet .mdb database file. This option is available if Microsoft Jet 4.0 database is selected as the destination.

Use Windows Authentication

Select to connect to the destination using Windows Authentication. This option is available for SQL Server destination databases.

Use SQL Server Authentication

Select to connect to the destination using SQL Server Authentication. This option is available for SQL Server destination databases.

Login

Enter the login name for the account. This option is available for SQL Server destination databases.

Password

Enter the password for the account. This option is available for SQL Server destination databases.

Database

Select the destination database. This option is only available for SQL Server destination databases.

Refresh

Click to refresh the database list. This option is only available for SQL Server destination databases.

Advanced Connection Properties

Shows the advanced properties that may be available depending on your destination data source.

See Also

DTS Basics

Transforming Published Data

Show:
© 2014 Microsoft