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 |
|
majkajs
Starting Member
2 Posts |
 Posted - 2010-07-25 : 14:37:14
|
| I am trying to invoke BCP as a task and keep getting the error below:[Execute Process Task] Error: In Executing "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\bcp.exe" "START-Staging.dbo.TAB_OnSiteProviders format nul -T -n -f prov.fmt" at "C:\", The process exit code was "1" while the expected was "0".I'm not sure if this is an authorization error or some kind of a permissions error. I've also tried just ".." between the database and table names. I am working on a local machine with admin priviliges, so I can't understand why this doesn't work. I am able to execute a task like BCP -v but nothing more useful. Any advice or pointers would be appreciated. |
|
|
majkajs
Starting Member
2 Posts |
Posted - 2010-07-25 : 19:07:02
|
Figured it out - those pesky square brakets [] |
 |
|
|
|
|
|
BCP Task Execution