SQL Server 代理作业 - 将结果导出到制表符分隔文件?

问题描述

我设置了一个在特定时间运行存储过程的 SQL 服务器代理作业.存储过程运行完成后，如何将结果导出到制表符分隔文件?

I setup a SQL server agent job that runs a stored procedure at a specific time. Once the stored procedure is done running, how can I export the results to a Tab Delimited file?

我使用的是 SQL Server 2008 R2.

I'm using SQL Server 2008 R2.

谢谢

推荐答案

如果您启用了 xp_cmdshell 并且您的帐户具有访问权限，您可以尝试:

If you have xp_cmdshell enabled and if your account has access you could try:

EXEC xp_cmdshell 'bcp "SELECT * FROM tblName" queryout "C:\tblNameData.txt" -T -c

另一种方法是像@Neil 提到的那样:SSIS.这是一个链接:

Another way is to do it as @Neil mentioned: SSIS. Here's a link:

http://decipherinfosys.wordpress.com/2008/07/23/ssis-exporting-data-to-a-text-file-using-a-package/