Failure to Load DTS package -- sql server dts

J
1/7/2004 12:41:27 PM

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

Allan Mitchell
1/8/2004 7:33:33 AM

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

[quoted text, click to view]

sql server dts : Failure to Load DTS package