Hi I m working on a simple SSIS package in which i m reading xml files from folders ,then import it in database,after import i just delete processed file,i want to move the faulty file that is not readable into separate folder,i m using Onerror event of the Dataflow task but i m facing the following issue. [File System Task] Error: An error occurred with the following error message: "The process cannot access the file because it is being used by another process.". Thanks Mak

Make sure all the connections , COm Objects are all Killed or are set to Nothing after they are used because of this You are getting this error. Regards, ManjunathRV

Thats because the file is still being used by the Data Flow task and hence you cannot move it from within the OnError event handler of the data flow task. Would suggest moving the file archiving process from the OnError event handler to the control flow and use "error precedence constraints" Check this to further your understanding on precedence contraints.http://btsbee.wordpress.com/

Thats because the file is still being used by the Data Flow task and hence you cannot move it from within the OnError event handler of the data flow task. Would suggest moving the file archiving process from the OnError event handler to the control flow and use "error precedence constraints" Check this to further your understanding on precedence contraints.http://btsbee.wordpress.com/

Thats because the file is still being used by the Data Flow task and hence you cannot move it from within the OnError event handler of the data flow task. Would suggest moving the file archiving process from the OnError event handler to the control flow and use "error precedence constraints" Check this to further your understanding on precedence contraints. http://btsbee.wordpress.com/ Ensure you maintain a notification(via email or any alternate mechanism) in place as to determine the files which were failed.Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog

Hi Raunak, I am very new to SSIS,can u please explore how to use notification in SSIS Thanks and Regards Mukesh SIngh

Check this to get you started on how to send mail notifications on error.http://btsbee.wordpress.com/