View Full Version : How to create a csv file from a query or table in SQL Server 2005


Guus2005
02-23-2011, 05:13 AM
Is it possible without using bcp or SSIS to create a csv file from a query or a table in SQL Server 2005?

Running a bcp requires xp_cmdshell, due to safety protocols i can't use that.
Creating a SSIS package requires cooperation from a different department i don't want that.

So i am looking for a different solution.

Thanks.