I can manually execute a simple DTS package that has
a 'Microsoft OLE DB Provider for SQl Server' connection.
Although when I try to schedule the same task the
following error is given.

The process could not be created for step 1 of job
0x99646A80FF6D8E44BCD580840B5DA56A (reason: The system
cannot find the file specified). The step failed.

You may be experiencing this

Service Pack and Version Compatibility Problems
http://www.sqldts.com/default.aspx?6,222,223,0,1

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Jeff Shumaker" <jshumaker (AT) tctitle (DOT) com> wrote