Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hayko98
Starting Member
29 Posts |
 Posted - 2012-01-30 : 16:56:58
|
| Hi all,I am trying to create a report and export to CSV file without column headers.When i run the query from SSMS and 'SAVE RESULTS AS..' CSV or text file it saves without headers.But when i am createing a job to run the query ,it exports with headers.I sat up OUTPUT Format (from Tools\Query Results\results To Text\Comma delimeted\unchecked Include column headers ....It still exports with headres.Any ideas how to do this? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-30 : 17:04:34
|
| how are you exporting from job? are you using bcp or some other utility?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
hayko98
Starting Member
29 Posts |
Posted - 2012-01-30 : 17:12:31
|
| Output file c:\......\abc.txt or .csv |
|
|
|
|
|
|
export to CSV file