It works when ran from command prompt but not when stored proc is ran?

Here is the stored proc:

CREATE PROCEDURE FW_BurtDTS
AS

set nocount on

--declare
--@filename varchar(20)

exec xp_cmdshell 'DTSrun /s circprod /u sa /p magnesium24 /n
DTS_PrePrint_Burt_Count_File'
exec master..xp_cmdshell 'DTSrun /s devtest /u sa /p /n
DTS_PrePrint_Burt_DBAR_File'
exec master..xp_cmdshell 'DTSrun /s devtest /u sa /p /n
DTS_PrePrint_Burt_Chksum_File'
exec master..xp_cmdshell 'DTSrun /s devtest /u sa /p /n
DTS_PrePrint_Burt_FN_File'
SET QUOTED_IDENTIFIER OFF




Here is the error:

output

----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
---------------------------
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy Data from
Results to C:\TMC\VAX\TMCCounts.txt Step DTSRun OnError: Copy Data from
Results to C:\TMC\VAX\TMCCounts.txt Step, Error = -2147217887 (80040E21)
Error string: Error opening datafile: Access is denied. Error source:
Microsoft Data Transformation Services Flat File Rowset Provider Help
file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 5
(5); Provider Error: 5 (5) Error string: Error opening datafile: Access
is denied. Error source: Microsoft Data Transformation Services Flat
File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun
OnFinish: Copy Data from Results to C:\TMC\VAX\TMCCounts.txt Step DTSRun:
Package execution complete.
(21 row(s) affected)


Shawn Smith
Database Administrator
Fort Worth Star-Telegram
817-390-7094
817-291-5240 cell
817-667-2757 pager
[Email Address Removed]MS Sql Server LazyDBA home page