Post reply

SSIS - ForEachLoop contains DF that fails at times. How can I keep iterating through loop?!

  • August 24, 2011 at 12:31 pm

    #242096

    Hello,

    A while back some folks on this forum helped me created a really good tool. I have a SSIS project that iterates through production servers and checks jobs.

    The control flow has a dataflow which gets a list of servers and a ForEachLoop Container.

    The ForEachLoop Container iterates through the list of servers.

    Inside the ForEachLoop is a script task and a Data flow. The script task is doing nothing but giving the current server through a messagebox.

    The Data flow has an OLE DB Source that gets the current server, creates a connection string, connects to the current server and tries to run a SQL Command.

    From there, there is a derived column. Then a OLE DB Destination.

    That is it.

    Question

    ======

    Sometimes the OLE DB source has a problem connecting. The whole project fails. How do I create some type of error trapping flow to bounce back to the ForEachLoop Container and get the next server?

    Thanks,

    Tony

    P.S. Original question that the forum helped me with.

    http://www.sqlservercentral.com/Forums/Topic1142962-391-2.aspx#bm1146287

    Things will work out.  Get back up, change some parameters and recode.

  • August 24, 2011 at 4:27 pm

    #1372880

    You can create an Event Handler and deal with it that way but if I understand your question correctly, you should be able to go into your OLE DB control, Go to Error Output, and select "Ignore Error" for all - by default it's set up to Fail Component, which in turn will fail the entire container.

    It would help greatly if you would attach your project...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

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

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