• The easiest thing to do is tell your vendor to stop sending you invalid files.

    There are many ways of handling errors in SSIS. Not sure if you can come up with one that would detect if an error is caused by this condition and not another condition that you do not want to ignore.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]