Will BCP run as a service under Win2K SQL Server 7?

Report this post to a moderator

I am not sure why you would want to...or how this would even work...
BCP is a command line tool.

--
Keith, SQL Server MVP


"Kris L. Billingsley" <kbilling@amtote.com> wrote in message
news:966101c27940$3befbbf0$3be
f2ecf@TKMSFTNGXA10...
> Will BCP run as a service under Win2K SQL Server 7?

Report this post to a moderator

>-----Original Message-----
>I am not sure why you would want to...or how this would
even work...
>BCP is a command line tool.
>
>--
>Keith, SQL Server MVP
>
>
>"Kris L. Billingsley" <kbilling@amtote.com> wrote in
message
> news:966101c27940$3befbbf0$3be
f2ecf@TKMSFTNGXA10...
>> Will BCP run as a service under Win2K SQL Server 7?
>
>
>.
>


Well Here's the story. I'm running BCP within a batch file
every morning to load yesterdays data. BCP will run under
the "AT" service but something is missing when run under
my new service. I must look for late files and load them
as necessary.

Make sense?

Report this post to a moderator

Services are unusual in subtle ways, and BCP was not written as a service.
The best you could hope for would be to write a service that then invokes
BCP, but that starts to sound alot like the SQL Server Agent.

Rather than using AT you might try the SQL Server Agent which has very
robust scheduling and is used for all kinds of stuff. A job can be
configured to run a command, such as your batch file, or TSQL, and can
actually conditionally continue or exit based on return values at each "job
step". If you havn't already, check it out, it might be just what you need.

James



"Kris L. Billingsley" <kbilling@amtote.com> wrote in message
news:966101c27940$3befbbf0$3be
f2ecf@TKMSFTNGXA10...
> Will BCP run as a service under Win2K SQL Server 7?

Report this post to a moderator

Kris,

Can you expand on "something is missing"? What errors do you get? Also,
there's an API (bulkload) for BCP that you might want to use instead of
shelling out to BCP itself perhaps.

> Well Here's the story. I'm running BCP within a batch file
> every morning to load yesterdays data. BCP will run under
> the "AT" service but something is missing when run under
> my new service. I must look for late files and load them
> as necessary.
>
> Make sense?
>

Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvfor...p?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq

Report this post to a moderator