• andre.pageot (10/25/2012)


    Excellent use of SSIS

    however I did spot a potential bottleneck, you could potentially get stuck in loop if the process that held the file open has halted or crashed or ended with a file lock still in place

    Consider the following as a replacement for your wait code, Hope this proves useful at times when things get stuck 🙂

    We have to draw the line somewhere when producing code (especially for demonstration purposes) which by nature will leave some things 'out of scope' and this was one of those cases. Thanks for posting, you offered a very nice addition (and in two languages no less!).

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato