Hi,

I am new to DTS world. I was able to save a dts package (in local packages)
and execute it manually without problem. I am trying to schedule it to run
daily but nothing happened on scheduled time. Could anyone please point me
out? Where can I check the log? Thanks.

Right click on the package -> Schedule Package.
This will create a job under Management -> SQL Server Agent -> Jobs.

Right click on the package -> Package Logs.
The SQl Server Agent must be started.

Does it work now? Any further assistance?

Good luck.

Jennie Pao wrote:

Whilst it is possible to Schedule a package by right clicking on the package
in EM and selecting schedule I prefer not to do this as it creates a
hexadecimal encrypted version of the command line. I prefer to use a
Operating System (CmdExec step to run DTSRun myself.

If the syntax is confusing then you could try here

Getting Syntax Help for DTSRun
(http://www.sqldts.com/default.aspx?301)

and don't forget this one

http://support.microsoft.com/?kbid=269074

--


Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com



"Jennie Pao" <email (AT) msn (DOT) com> wrote