I've been trying to get a stroed procedure to execute a DTS and have come up
with a baffling problem. The DTS has a Text FIle Source connection whice the
file name is set via a global variable. When i run the DTS from the
Enterprise manager it runs fine, importing a file from across the network,
however when trying to run it from a stored procedure the steps prior to the
data import work fine but i get an error as follows;

Step Error Source: Microsoft Data Transformation Services Flat File Rowset
Provider
Step Error Description:Error opening datafile: Access is denied.

In the stored proc i am still conecting with the same user name & password
as i do with the enterprise manager. I am at a loss as to why this is
happining ... any ideas or suggestions ?

Hello Peter,

How are you calling it in an Proc?

xp_cmdshell? Have look here

http://msdn.microsoft.com/library/de...aa-sz_4jxo.asp


It almost certainly is permissions/transferral of executor.

Allan