sql server dts: Running DTS package as a Job -- sql server dts

Running DTS package as a Job

Michael marrero
1/14/2005 9:48:57 AM

sql server dts:

I am trying to run DTS pakage as a job and the job fails because it
does'nt have read access to required files in the file system. The job
runs to completion when run from the console but not from CmdExec in the
job. The files and directories have full control for all users. Any
ideas.

*** Sent via Developersdex http://www.developersdex.com ***

Re: Running DTS package as a Job

Allan Mitchell
1/15/2005 7:35:26 AM

This article usually has the answers

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

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know

[quoted text, click to view]