Post reply

Ignoring Connection Errors in a Package with Multiple OLE DB Source

  • June 9, 2009 at 7:07 pm

    #132864

    I've got an SSIS package which have multiple OLE DB Sources in a Data Flow Task. When one of the source is down, I get a connection error and the task fails. What I want to happen is if one OLE DB Source is down, the data flow task should continue with the logic and ignore the failed connection. I have set the MaximumErrorCount of Data Flow Task to a big number thinking that it will solve the issue but it didn't.

  • June 26, 2010 at 3:17 pm

    #1185391

    I'm having the same issues, does someone have a solution for this. I have tried a lot of options in the "error output" tab (redirect row and ignore failure), but that doesn't help.

    Regards,

    Marco

  • June 27, 2010 at 3:48 pm

    #1185448

    I have found my solution at this link:

    http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/f4842c73-6439-4fc0-ad59-cf74f9ef7b83

    Regards,

    Marco

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

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