sql server dts: problem on scheduling dts's -- sql server dts

problem on scheduling dts's

Roy Goldhammer
3/25/2007 12:00:00 AM

sql server dts:

Hello there

I have Sql server 2000 SP4.

I've just created 2 DTS's that create text files form views on my databases.

When i run it from dts managment it works fine

But when i scheduale the dts. the job run failed: Access denied

what i need to do in order to run it propery?

Re: problem on scheduling dts's

Allan Mitchell
3/25/2007 1:54:27 PM

Invariably this type of problem is to do with permissions.

Have a look here

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

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.