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!
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!