One file, multiple SSIS packages: problem? 1

[tigerjade]

I'm trying to design an app that will monitor a folder for delivered files (via FTP, from external sources), and then kick off associated SSIS packages. My question is (and I'm asking now, so I can determine the best way to build this thing) is, if a file is required by more than one package, and the packages run simultaneously, will there be collision issues, or can multiple packages access the same file at the same time without a problem?

Thanks!

"Always code as if the person who ends up maintaining your code will be a violent psychopath who knows where you live." -- Martin Golding

 

[MDXer]

you will have contention issues. your best bet is to have the file contents loaded into a stage table where the contention will not be as great.

 

[tigerjade]

Okay, duly noted. Thank you!

"Always code as if the person who ends up maintaining your code will be a violent psychopath who knows where you live." -- Martin Golding