Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,685 questions
How to get a CSV file from a T-SQL in SQL Agent
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 75%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
LUIXANY COLISEE
0
Reputation points
I am using SQL agent to schedule a task. This task is the execution of a script that performs a query to several databases and concatenates the output. I have managed to obtain a file but not a CSV file, that is, I cannot obtain a file separating the fields by commas or periods, it is rather a txt file with columns. How can I achieve this? In the options configuration I do not see the option to define these output parameters in the files that result from a T-SQL
{count} votes
-
Erland Sommarskog 116.1K Reputation points MVP2024-09-26T21:40:12.4766667+00:00 What sort of job step are you running? Can you share the code of your script?
-
GlockByte 161 Reputation points2025-01-24T16:40:24.2966667+00:00 Are you concatenating the results or simply doing a union all to the results?
Does your script use BCP?
bcp "SELECT column1, column2, column3 FROM sometable" queryout "C:\path\to\output.csv" -c -t, -T -S servernameThe -t gives you a comma deliminator
Sign in to comment
Sign in to answer