Post reply

How to stop package from failing when a connection has an error?

  • September 8, 2010 at 12:46 pm

    #225938

    I have a package that transfers data from several different servers. I group all tasks related to one server in one sequence container. I have a Failure constraint coming from the sequence container to a send email task as well as a completion constraint coming from each sequence container to the next one to be executed. If one of the transforms in the sequence container errors I don't want it to crash but rather run the send email task and begin the next sequence container. Right now I have an error with an oledb connection and the package fails inside the job that I run it from rather than sending the email and continuing. Any ideas whats wrong?

  • September 8, 2010 at 1:18 pm

    #1218204

    Have you taken a look at the MaximimErrorCount for both the Container and the Package?


    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]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply