How to schedule a DTS package using the Schedule Package option (Enterprise Manager)

How to Install SQL Server 2000

How To

How to schedule a DTS package using the Schedule Package option (Enterprise Manager)

To schedule a DTS package using the Schedule Package option

  1. In the SQL Server Enterprise Manager console tree, expand Data Transformation Services, and then click either Local Packages or Meta Data Services Packages.

  2. In the details pane, right-click the Data Transformation Services (DTS) package you want to schedule, and then click Schedule Package.

  3. In the Edit Recurring Job Schedule dialog box, complete the required information.

Note  The scheduled package will be executed by SQL Server Agent using the permissions specified during server registration. If Windows Authentication was used, then SQL Server Agent will attempt to load the package using its own security, which may not be sufficient to load the package. For more information see Handling Package Security in DTS.

See Also

Scheduling a DTS Package for Execution