DTS import scheduling in SQL Server

#1

I have a DTS package that works fine when kicked off
interactively in SQL Server Entreprise Manager. (This
package deletes a table, imports via ODBC and then fiddles
with the data using SQL statements.)

When I try to schedule it to run at midnight on Mondays,
it fails with an OS error. Something to do with OS-level
access. Sorry can't be much more specific.

Any possible causes anyone can think of?

Thanks.

#2

Usually the fix to this problem can be found here

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

--

----------------------------
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

"pvp" <peter.van.peborgh (AT) philips (DOT) com> wrote

Quote:

I have a DTS package that works fine when kicked off
interactively in SQL Server Entreprise Manager. (This
package deletes a table, imports via ODBC and then fiddles
with the data using SQL statements.)

When I try to schedule it to run at midnight on Mondays,
it fails with an OS error. Something to do with OS-level
access. Sorry can't be much more specific.

Any possible causes anyone can think of?

Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS import scheduling in SQL Server

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS import scheduling in SQL Server - 09-17-2003 , 07:58 AM

Re: DTS import scheduling in SQL Server - 09-17-2003 , 08:07 AM