Is DTS possible to schedule like a job process?

[EVH316]

Hi,

Is DTS can automate like schedule job? How?

Thanks in advance

[ck9663]

Create your DTS package and schedule that package to run as necessary.

-- CK

[Delerna]

Right click on the DTS and select the "Schedule Package" option.
Follow the prompts, Its fairly intuitive.

Once completed you will find the schedule under
YourServersName/Management/SQL Server Agent/Jobs
in enterprise manager.

You can fine tune/edit the schedule timing etc there
You can enable/disable the schedule or even manually execute the schedule
There is Job run history, Job run outcome etc etc.