Databases Reference
In-Depth Information
just click on the Package name text entry box, it will fill in the pack-
age name for you. At this point, the dialog should look something like
Figure 16-26 .
Figure 16-26
With the package in the Stored Packages area, you can easily run it by right-
clicking the package name and selecting Run Package. What we really want
to be able to do, however, is schedule to have our package run on a regular
basis so we don't have to think about it. Scheduling SSIS packages to be run
periodically can be accomplished by using the SQL Server Agent. The Agent
is its own process which you can access by opening a connection to the
Database Engine as shown in Figure 16-27 .
 
 
Search WWH ::




Custom Search