> Does your system account have right to the destination box?
> Does your path have spaces in the path or filename?
>Is the destination box on the Netwrok
>Is the destination box plugged in 8-)
>Whats the output from the statement.... [/SIZE][/QUOTE]
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP host data-file
Any ideas? Thanks!
Originally posted by Brett Kaiser
Does your system account have right to the destination box?
Does your path have spaces in the path or filename?
Thanks Brett and rdjabarov.
Can you tell me how I can check if my SQL Server Service account have right to create files on the destination? And tell me more about the SQL Service account? Thanks in advance.
Originally posted by rdjabarov
Brett meant your SQL Server Service account. It should have the right to create files on the destination. Based on the error you posted it appears that it doesn't.