Choose a Destination, Define Transformation of Published Data Wizard
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.