BCP questions ???

[Rob Fritz]

I am tying to call BCP to output the contents of a table to a text file from with in a stored procedure.
The procedure will be called from an ASP page ...
My question is were does the file get created ??? I want to create the text file on server ONE and SQL server is running on server TWO and IIS is running on server THREE... do i have to have a drive letter mapped to server ONE and if so is it mapped on the SQl server or the IIS server ....

ie:
exec master..xp_cmdshell bcp db..table out h: est.out -Uxx -Pxx -Sx

thanks for any help on this subject ...

Rob

[MAK/AnanthaKumar Muthusamy]

Interesting question.


Do Map network drive in sqlserver server not in IIS.

I think it will work.


good luck.


MAK


------------
Rob Fritz at 9/2/99 1:10:04 PM


I am tying to call BCP to output the contents of a table to a text file from with in a stored procedure.
The procedure will be called from an ASP page ...
My question is were does the file get created ??? I want to create the text file on server ONE and SQL server is running on server TWO and IIS is running on server THREE... do i have to have a drive letter mapped to server ONE and if so is it mapped on the SQl server or the IIS server ....

ie:
exec master..xp_cmdshell bcp db..table out h: est.out -Uxx -Pxx -Sx

thanks for any help on this subject ...

Rob