Calling Store Procedure From Aspx

hi , I would appreicate your help, I have created a store procedure in MS sql server 2000 to be called from aspx page.


The store procedure will have multiple functions:


checking if a file exist in c:data


if file exist, it will use zip file command line to unzip the file and then run DTS package to upload the database.





The issue I am having is when I run the store procedure from MS query analyzer,I get a confirmation that the whole procedure ran successfully, but when I call the same procedure from aspx, althought the store procedure ran successfully, but I did not get any confirmation to the user in the aspx page to notify the user that the process successed.... here is my code in where I think is not working,


CREATE PROCEDURE p_on_demand_dts_sales_option_price_report_3_ftest


@id int , @msg_output varchar(28) output


as


declare @varcmd varchar(255),@FileExist int


select @varcmd = null


select @varcmd ='dir :Data_on_demandsales_option_price_report.csv' -- check if file exist


EXEC @FileExist = master..xp_cmdshell @varcmd


set @msg_output = 'The file exists'


Return 44





+++ The above store procedure use command line to check if the csv file exist, its suppose will return a output parameter and a return # BUT it did not. To my surprise, when I modify the above store procedure like this, it work


-----


CREATE PROCEDURE p_on_demand_dts_sales_option_price_report_3_ftest


@id int , @msg_output varchar(28) output


as


set @msg_output = 'The file exists'


Return 44





The second procedure does not do anything, except take input parameter and return a message output and return, this work.





since the second procedure works, it means that the code in aspx is correct, but I have no clue why it does not return output parameter and return # in the first procedure.





I would really appreciate anyone who could help.


thanks





ehx5