export tabel wihout xp_cmdshell

[jordanking]

Hello,

I read the previous post (.csv export possible? sept 05 2008) about exporting csv files and the solutions were to use the command function xp_cmdshell with DTS or BCP. I can not do that. I am working with sql server 2005 workgroup which does not have SSIS and as a result I can not create a DTS package that can be run inside a Job. The documentation on xp_cmdshell discourages activating this command...

So what I am wondering is, how can I export one table, from within a stored procedure, into a .csv file?

.....
I'd rather be surfing

 

[mrdenny]

Without using xp_cmdshell and calling either BCP or SSIS you can not.

It is recommended that you not use xp_cmdshell.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog