BCP won't run as a Service? Trying to Schedule BCP without the "AT"cmd

[kbilling]

I wrote a service that checks for a tag file with a date in it. I capture the date and then run a batch file to load the data in question. It works fine running from the "AT" service or a cmd window but not from my service. Tried everything with security and believe that's OK. However I found that a CMD.EXE window that is run from a service in Win2k SP2 doesn't pick up the system path when it starts. I wonder is anything else (like permissions) doesn't get inherited.
The load seems to go along fine and even makes the >>%log% file with all of the appropriate entries but then it must get an error and back out all of the new records because when it's done they are not there.

Thanks,
Kris L. Billingsley

Using SS7 sp2 with the BCP program from 6.5 due to date format issues.

 

[MAK9974]

why cant u use DTS?

 

[kbilling]

DTS not nearly fast enough. I must load half million records each to 6 databases.!!!!