Matt, Can you see anything I could do to speed up the code below?

using System;

using System.Data;

using Microsoft.SqlServer.Server;

using System.Data.SqlTypes;

using System.Data.SqlClient;

using System.IO;

public class SQLCLRIO

{

[Microsoft.SqlServer.Server.SqlProcedure]

public...

Cheers Matt,

That document looks pretty useful, its pretty hard trying to find a decent website on this topic.

MY CLR is currently exporting a table with 98,308 rows in 3...

slightly updated quasi working version below is only writing the last row of the table, So I guess I need to either

A. build up a buffer

B. Write or...

i havent tried to compile the code below but this would be my attempt without knowing c#

using System;

using System.Data;

using Microsoft.SqlServer.Server;

using System.Data.SqlTypes;

using System.IO;

public class SQLCLRIO

{

conn = new SqlConnection(

...

Hi Matt,

Re: "Your CLR should do both the building of each row AND the streaming of the data out", thats what I need thanks then I can avoid slow performing...

thanks stewart,

I've already written the c# class so I'm not a completely new to c#

I'm looking for help with achieving the above with something like

http://dotnetguts.blogspot.com/2007/01/exporting-datatable-to-csv-file-format.html

(without the front end button click...

as long as != flexible

I would have to do something like run an SSIS package programmatically

e.g.

create an export package

configure an agent job to run the package

call sp_start_job from proc

all of...

thanks Stewart for the suggestion but SSIS doesnt offer the flexibility I need....

e.g. the filename is dynamic, the source could be dyanmic. You could say am trying to replicate SQL...

SELECT TT.ID,

CASE WHEN TT.ID = -1 THEN 'NOVALUE' ELSE T.IdName END IDNAME ,

VALUE1

FROM #tmpTran...