Exporting data

[RitchieBoy]

I have need the ability to output(export to a csv file) the contents of either a Hash table or a Table Variable from inside a STORED PROCEDURE.

Does anyone know how to set the rowsource of a DTS dynamically from inside a stored procedure, or alternatively can anyone explain the bcp utility to me and how i can use it to export from either a Hash table or Table variable into a csv file.

I have tried the help(obscure examples) and several books with no joy

Any method anyone can explain to me i will be happy to use

thanx in advance !!

 

[markVII]

Use xp_cmdshell to export data into OS file; you also could run DTS package from command line (even using xp_cmdshell) using dtsrun utility