Specify DTS Package
If transforming published data has been enabled in the publication, you must specify the DTS package to use with this subscription.
These are the options available on the Specify DTS Package page of the Create Push Subscription Wizard.
Select this option if the DTS package is located at the Distributor.
Select this option if the DTS package is located at the Subscriber.
If you select the Subscriber option and the Subscriber is running SQL Server, you can also click the List Packages button. This will connect to the Subscriber and retrieve the list of packages created for use with replication. Such packages can be created manually or by using the Define Transformation of Published Data Wizard.
Enter the name of the DTS package that will be used with this subscription.
Owner Password (if required)
Enter the owner password for the DTS package if required.