Post reply

Where is the failure constraint?

  • May 16, 2012 at 12:49 pm

    #392273

    Hello,

    I am trying convert a stored procedure into an SSIS package. I thought SSIS would do a better job. Honestly, I'm starting to hate SSIS.

    I have a Foreach loop container. I have a script task in the container.

    I am checking the Foreach Loop container in the script tasks. I thought that each component had a onsuccess constraint (green) and onfailure constraing (red). However, I only see a green constraint. How do you add a failure (red) constraint?

    I tried to add a constraint, but the drop down list only lists the ForEach container.

    Again, how do you add a failure (red) constraint?

    Thanks,

    Tony

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

  • May 16, 2012 at 2:13 pm

    #1488666

    Alright, I changed the constraint to failure. It turned red.

    I then clicked on the scripttask and there was a green constraint also.

    OK, I'm good on this now.

    Thanks.

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

  • May 16, 2012 at 2:18 pm

    #1488670

    WebTechie38 (5/16/2012)

    Hello,

    I am trying convert a stored procedure into an SSIS package. I thought SSIS would do a better job. Honestly, I'm starting to hate SSIS.

    I have a Foreach loop container. I have a script task in the container.

    I am checking the Foreach Loop container in the script tasks. I thought that each component had a onsuccess constraint (green) and onfailure constraing (red). However, I only see a green constraint. How do you add a failure (red) constraint?

    I tried to add a constraint, but the drop down list only lists the ForEach container.

    Again, how do you add a failure (red) constraint?

    Thanks,

    Tony

    Create a green constraint, then double-click it to change the value to Failure.

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

  • May 16, 2012 at 2:19 pm

    #1488671

    Sorry for the late post that looks like a dupe. I had a window sitting in Reply-mode and got distracted. Happy you got it sorted.

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

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

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