Is there a way to create a Text File from a SQL Table using SP? 1

[meny21]

Hi Guys!

I have this situation, I need to create a flat file from a SQL table that I got, but I don't know how to do it inside an SP... I tried with DTS and it Works good....

The thing is that I need to do it in a SP and not on DTS, I tried to find the DTS code in order to put it on a SP but I couldn't find any...

Also do you know if there is an Easy clause like "Select ... Into" but instead of create another table creates a Text File? also could be use with delimiters?

Thanks for any suggestions

<MR>

 

[sunila7]

Take look at BCP command. Here is a link to it.

http://msdn2.microsoft.com/en-us/library/ms162802.aspx

Sunil

 

[meny21]

Hi Sunila,

Thanks for the information, I think this is what I need... just when I tried to put the BCP in my SP on SQL 9.0 Version it doesn't recognize this command... did you use it before?

Thanks!

MR

 

[sunila7]

Yes I have used it before. Take a look at this link.

http://www.simple-talk.com/sql/data...ng-csv-files-using-bcp-and-stored-procedures/

Sunil