DTS Package Location
The following options are available on the DTS Package Location page of the Define Transformation of Published Data Wizard.
Options
At the Distributor
Select to save the DTS package at the Distributor.
At the Subscriber
Select to save the DTS package at the Subscriber.
Use Windows Authentication
Select to connect to the selected server using Windows Authentication. This option is available for SQL Server destination databases.
Use SQL Server Authentication
Select to connect to the selected server 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.