Scheduled DTS Package won't run

If you've got a scheduled DTS Package that won't run, it's probably a simple fix.

The error we got was "reason: the system cannot find the file specified."

The job would run just fine when manually started, but scheduled jobs would fail.

The reason is irritating -- SQL Server doesn't include the path to "DTSRun.exe"

So you'll need to add that path to your PATH environmental variable, or edit each job you create individually.

To edit the job, go the the STEPS tab, double click the Step, and manually edit the command that calles DTSRun.

You'll find DTSRun.exe in tools/binn.