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: 283

Filed under:
|
|

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

Related posts about ssis

Related posts about file