SSIS process files from folder
Posted
by RT
on Stack Overflow
See other posts from Stack Overflow
or by RT
Published on 2010-03-19T16:30:14Z
Indexed on
2010/03/27
22:43 UTC
Read the original article
Hit count: 280
Background:
I've a folder that gets pumped with files continuously. My SSIS package needs to process the files and delete them. The SSIS package is scheduled to run once every minute. I'm picking up the files in ascending order of file creation time. I'm building an array of files and then processing-deleting them one at a time.
Problem:
If an instance of my package takes longer than one minute to run, the next instance of the SSIS package will pick up some of the files the previous instance has in its buffer. By the time the second instance of teh package gets around to processing a file, it may already have been deleted by the first instance, creating an exception condition.
I was wondering whether there was a way to avoid the exception condition.
Thanks.
© Stack Overflow or respective owner