Thanks to both of you, both ideas both fine except there seems to be a data issue in the sense that in some files do not have all the line,...

Thanks Rob, will try and let you know the results

Thank you all for your help, sorry for the late response, but I have been away for a week. Gave cluster service account permission to SQL server and it works...