SQL Server provides you the capability of scheduling when a package is going to run. To schedule a package:
Select the package from SQL-EM.
- Select Schedule Package from the menu. This will bring up the Edit Recurring Job Schedule screen. Click the View Image button to see what it looks like.
- From this screen, define when you want a package to run. Click the View Image button to see what this screen looks like.
Running a package is relatively simple. Click the View Slide Show Link below.
View Slide Show
Running Sql Package
The next lesson will introduce you to the important features of the DTS Wizard.