the LocalHost that I have mentioned here is just for the example. I have given the Fully qualified Server name itself.But still the error is the same.

The Source and destination folders are as follows when i debug,

Source: "\\\\Localhost\\test\\"

Destination: "\\\\Localhost\\test1\\"

though in the DB these are stored as, "\\Localhost\test\" and "\\Localhost\test1\"

Code: 0xC002F210 Source: Execute SQL Task Execute SQL Task Description: Executing the query "EXECUTE DBName.dbo.SPName ...

Updating with the Actual error I am encountering in a sql job

First of all I would like to thank Rookie as my issue is being resolved with the help of the link you had provided in your reply. Also wanted to...

Thanks a lot for the Help...

This was quite a Learning for ME 🙂