Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

BCP will not run as scheduled task in server 2008

Status
Not open for further replies.

bmacbmac

IS-IT--Management
Jan 26, 2006
392
US
Hello. I have a BCP script written in a batch file. The BCP process imports a delimited text file into my database. The file runs great if I double click the file, however the BCP will not execute when I run as Server 2008 scheduled task. The task itself is running... I can add another generic process like creating a text file or something, the action will complete. But nothing happens with the bcp commands.

SQL Is running under the local administrator account
Scheduled task is set up under the same local administrator account
I can get OSQL processes to run fine, but BCP will not.

Any ideas of something I can try?

Thanks!

 
Figured it out... I had to set the 'start in' to the directory that contains the .bat file (in server 2008 scheduled task).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top