|
Hi , I am trying to copy the file using Robocopy in SQL. It give me following message:- But when i run using XP_cmdshell it work fine. Actullly it is not identifying my Destination folder where i want to copy . Pls help. The feild Dest - is empty.
(comments are locked)
|
|
Sounds like a permissions error - does the userID that's running the job have access to the directory?
(comments are locked)
|
|
I would guess that this is an issue to do with QUOTED_IDENTIFIER - but really, given that you have just put in the error message and not any detail about what you are trying to run, I'm a bit lost for suggestions.
(comments are locked)
|
|
Have you tried specifying a destination directory?
(comments are locked)
|
|
Please post the actual robocopy command you have used. There are a multitude of switches and parsing this via T-SQL can be tricky.
(comments are locked)
|


Given that both @Matt and I are coming at this from different sides, perhaps if you told us what you're trying to achieve (SQL Server commands, version of SQL Server etc), then we might be able to help more effectively!