Can't Find CSV-file After Using BCP-utility In Stored Procedure

Hello peopleI have an issue with the Bulk Copy Program-utility.When I execute the BCP in the commandline, it will create a CSV-file.Code in commandline:




Code Block

bcp.exe PCVO.dbo.tblOpleidingen out "C:planning.csv" -c -t";", -eE:Rakoerror.log -Uxx -Pxx -Sservername
Code in stored procedure:




Code Block

USE [PCVO]
GO
/****** Object: StoredProcedure [dbo].[sp_ExportAccessToCSV] Script Date: 01/19/2008 16:36:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[sp_ExportAccessToCSV]
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

DECLARE @sql varchar(8000)

SET @sql = 'bcp.exe PCVO.dbo.tblOpleidingen
out "C:planning.csv" -c -t";", -eE:Rakoerror.log -Uxx -Pxx -S' + @@servername

EXEC xp_cmdshell @sql

END
Code in C#-application:



Code Block

String connectionString = "Data Source=THUIS-LENNY\SQLEXPRESS;Initial Catalog=PCVO; Integrated Security=True";

System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(connectionString);
con.Open();

System.Data.SqlClient.SqlCommand da = new System.Data.SqlClient.SqlCommand("sp_ExportAccessToCSV", con);
da.CommandType = CommandType.StoredProcedure;
da.ExecuteNonQuery();
When I use the BCP-utility inside a stored procedure (called in a C#-application),using the xp-cmdshell, I can't find the created file. I even don't get an error or warning message.Can somebody help me?Thanks in advance,G VossiusNB: I'm using SQL Server 2005, Visual Studio 2008 C# EE