Hi All
If I run the DTS package from the server console it runs
ok. A job calls a SP which is really just a wrapper to run
the DTS package. When that runs it says "Fatal Error:
Failure to load DTS package '<packagename>'"
Any ideas?
Many thanks
J

Same package , same server?
How do you call the package in the SP/Job?

Have a look at this

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

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"J" <anonymous (AT) discussions (DOT) microsoft.com> wrote