Check the permissions again... especially for the account that *SQL* server is
running under.... which is not the same as the account you're using when
running EM.
--Tomm

> -----Original Message-----
> From: GREG ZIMMERMAN [mailto:gzimmerman@w...]
> Sent: Thursday, December 06, 2001 12:40 PM
> To: sql language
> Subject: [sql_language] Running a DTS from Query Analyzer
>
>
> Hi,
>   I have created a DTS to import a .txt file from the C: drive of the
> machine SQL is running on.  When I execute it from EM it runs fine, however
> when I include it in a stored procedure it cannot find path to the file.  It
> does start the DTS because it drops the existing table and creates the new
> table.  I have granted full access to everyone for the folder and all
> contents and have shared the folder and all contents.   Is there a way to
> create a DTS from the Query Analyzer?  I have been looking in help and the
> manuals I have but no luck so far.
> Thanks
> Greg
>
> $subst('Email.Unsub').