Can I export to .txt? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Can I export to .txt?

I don’t see the option of exporting to .txt. Can I?
You can right click a table in Enterprise Manager and select export (this uses DTS). When you get to the destination screen of the wizard choose Text File. Or you could use BCP – look in books on line about this one. Or you could write a DTS package (more complex and only really worth it if you are going to do the export on a regular basis). Alternatively you can write a query in Query Analyser and same the results to a text file…
I guess the answer is I can’t do it from Reporting Services.
]]>