I have a stored procedure which generates a few files and stores it in a particular location. When I change the location to another drive I get this error.
THE ERROR NUMBER IS 7321
THE ERROR MESSAGE IS:An error occurred while preparing the query "select * from \\VM_FILESERVER\it$\SFPC FL Citizens Takeout Data\SFPC FEB 2014 TAKEOUT4_21_2014_51218357\SFPC_FEB_2014_TAKEOUT_4_21_2014_POLICY_DETAILS.TXT" for execution against OLE DB provider "MSDASQL" for linked server "(null)".
Can some one help me out with what might be the reasons that are causing this ?