Save job results to a file minus header information

sql server 2005
There is a job that returns a date.The goal is to have a flat file of
dates with no header information.
Is there a way to do this in sql server or you have to find DOS scripts
to clean that out...How are you causing the output to the file? osql? sqlcmd? Job step output?
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Massa Batheli" <mngong@.gmail.com> wrote in message
news:1162987757.059162.108050@.b28g2000cwb.googlegroups.com...
> sql server 2005
> There is a job that returns a date.The goal is to have a flat file of
> dates with no header information.
> Is there a way to do this in sql server or you have to find DOS scripts
> to clean that out...
>|||I have the same question,
"Save job results to a file minus header information "
with the following exception. I am using SQL 2000
I am scheduling a stored proc to run using SQL Server Agent.
"Arnie Rowland" wrote:
> How are you causing the output to the file? osql? sqlcmd? Job step output?
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "Massa Batheli" <mngong@.gmail.com> wrote in message
> news:1162987757.059162.108050@.b28g2000cwb.googlegroups.com...
> > sql server 2005
> > There is a job that returns a date.The goal is to have a flat file of
> > dates with no header information.
> > Is there a way to do this in sql server or you have to find DOS scripts
> > to clean that out...
> >
>
>|||Sorry guys failed to update this
Regular internal sql server job that writes to a flat file ...
Thanks for your time
Massa|||Your Job step could direct output to a file,
OR the Job step itself could shell out to OSQL and allow OSQL to direct
output to a file.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Massa Batheli" <mngong@.gmail.com> wrote in message
news:1163703951.849624.192880@.h54g2000cwb.googlegroups.com...
> Sorry guys failed to update this
> Regular internal sql server job that writes to a flat file ...
> Thanks for your time
> Massa
>