Check and make sure ''E:\FileTransfers\Inputs\Emp\' + @FileName + '.txt''') exists on the SERVER instead of client, and check if read permission is assigned to the user running this SP

Looks like the data was cached. Try runing dbcc dropcleanbuffers first. Also you can just run a simple query without "for xml explicit" and see if you still get an...