I need a flat...
-
file with formatting, no header and delimiters. I want to set this up as a job so I can't really set the options in Query Alalyzer. Is my only choice to do a BCP?
thanks
-
You can use osql as in the following post:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=136563#bm136607
I seem to be getting a lot of mileage out of that post.
The down side to it is that I think you would need to use PRINT statements within a cursor instead of just a standard SELECT, but perhaps you know of a way to suppress reporting headers in a SELECT.
-
.... or you could use DTS, but bcp would be my choice. It depends what you're used to or comfortable with, GUI or command line.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply