> The DTS package reaches out to another server on the network to pull
> in a text file. The DTS package runs fine when launched from
> Enterprise Manager or if scheduled as a job. It FAILS to import the
> file when launched from an ASP page. The other tasks in the job run
> fine (backup and delete from table, etc.), but when it attempts to run
> the import task it fails. The package log shows "Access is Denied".
> Does anyone know what user or user group from the SQL server needs to
> be added to the share on the file server for this to work when called
> from ASP page? Thanks in advance.
>
> Paul
>

"Allan Mitchell" wrote:

> Hello Paul,
>
>
> Have you seen this article which may help?
>
> http://support.microsoft.com/?kbid=252987
>
> --
>
> Allan Mitchell
> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
> http://www.konesans.com
>
> > The DTS package reaches out to another server on the network to pull
> > in a text file. The DTS package runs fine when launched from
> > Enterprise Manager or if scheduled as a job. It FAILS to import the
> > file when launched from an ASP page. The other tasks in the job run
> > fine (backup and delete from table, etc.), but when it attempts to run
> > the import task it fails. The package log shows "Access is Denied".
> > Does anyone know what user or user group from the SQL server needs to
> > be added to the share on the file server for this to work when called
> > from ASP page? Thanks in advance.
> >
> > Paul
> >
>
>