I have a DTS package that loads a text file from a folder on the Server that hosts the SQL Server to a table in the SQl database.

I can do this comfortably if I execute the DTS package through Enterprise Manager on my machine. I(as an user) have access to the Server that hosts the SQL server and I am able to provide a path like L:\Microsoft SQL Server\MSSQL\FDCHClaims_Info.


But when I execute the DTS package from a client application, the application does not seem to have access to the folder on the Server that hosts the SQL server. When I try and execute the DTS Package, I assume that the SQLAgent will have access to the folder. But it take authentication of the client and since the client is not authorized to access the folder, the DTS fails.

Is there a way to get to the file system of the Server that hosts the SQL Server through the database authentication.

You can try this

1-create a job for the dts package
2-Create a store procedure that calls that job and give the client rights to run that store procedure.


Jaime E. Maccou

hi, i want to save the image file on sql server's file system through the tools of database, not using asp upload and any other involving upload of the file. This approch i have used in oracle using java source and utl_file package. i want the analogy of this in sql server 2000.

please help urgent.
thanks in advance