Force SELECT to file.

[grnzbra]

I can write a SELECT statement in Query Analyzer and then click on an icon and have the output go to a file. Is there any way to include in the SELECT statement something to tell SQL Server that I want the output to go to the file?

 

[philhege]

Sounds like s job for PowerShell, or an SSIS package, or bcp. It's not a feature of native T-SQL. SSMS has the capability to direct output to a file, and even include the query text, but it's not scriptable AFAIK.

-----------
With business clients like mine, you'd be better off herding cats.

 

[grnzbra]

Thank you for the clarification. I'll check into SSIS and bcp.

 

[SQLBill]

Is this a script that is always run the same way? If so, you could put it into a job and have the job output the results where you want.

-SQLBill


The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[egodette]

sqlcmd -U<user> -P<password> -S<server> -d<database> -I<sql query from input file> -o<output file>