June 12, 2006 at 11:52 am
I am getting following error when I try to exectue a piece of code that would move syslogins
rlx\svcDBASQLAdmin. SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP host data-file. Process Exit Code 1. The step failed.
above error occurs when following code is executed as a job
bcp master..syslogins out S:\logins\TransactionLogs\syslogins.dat /N /S sqlser /U sa /P test123
i have given user rlx\svcDBASQLAdmin full control to S:\logins\TransactionLogs share. dont know why would i get the error message above.
June 13, 2006 at 11:21 am
The error that you are getting is due to either the fact that the directory does not exist or the account does not have write authority to your bcp target. However even if you fix these things it will not do you any good because you cannot move user logins via bcp anymore <period>. Either use the DTS transfer logins task or look at this KB article:
http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;Q246133
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 13, 2006 at 12:08 pm
I think the article you mentioned probably only applies to the restore of a db. I am working off of this
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_1_013_9t0p.asp
Let me know what you think.
thanks
June 13, 2006 at 12:15 pm
I have resolved the issue above. It had to do with permission to the folder.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply