Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rauk10
Starting Member
16 Posts |
 Posted - 2008-08-06 : 14:44:46
|
| I am new to SQL SERVER. I want your help. I want to have a new job that will automatically bulk copies to the text file. I had my stored procedure running. But I cannot use the BCP command to automatically copy to the text files. Whenever I try to run the job, job always fails. But if I use the BCP command in the command prompt it runs well. Is there any permissions that I need to grant before using BCP command on the job? Any help would be appreciated. Thank You |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-06 : 23:39:35
|
| If you want to bcp data to file on remote location, sql agent service account needs permission on that location. |
 |
|
|
|
|
|
BCP help needed