I created a package in SSIS where I transfer Data from XML files to a database table using a foreach loop.
I have a contraint on the database table and when one of the XML files hits that constraint, the XML file should get moved to a certain ErrorFolder.
So I created an EventHandler "OnError" which holds a FileSystemTask.
See the configuration of the FST below
But I always receive the error "The process cannot access the file because it is being used by another process."
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.