Post reply

Data Flow Task Result Value

  • July 29, 2008 at 9:14 am

    #122689

    [font="Arial"][/font]

    I am having an odd problem.

    In a pretty long SSIS package, I need to perform SQL 2005 Script Task (the last step!) after Data Flow Task irrespective of the result of Data Flow Task. I used a blue arrow (Completion) from Data Flow Task to SQL 2005 Script Task in my package control flow diagram.

    The last step (SQL 2005 Script Task that executes dynamically constructed SQL Statement from the package variable) does not start at all.

    How could I return a specific Task Result from Data Flow Task? What else could I be missing?

    Thanks in advance.

    Alex

  • July 29, 2008 at 10:21 am

    #849956

    Please verify, In constraint editor, Constraint options, Evaluation operation point to "constraint" and you have selected value as completion. That's all I can think of unless you have more constraints coming from data flow task.

    -V

  • July 29, 2008 at 10:49 am

    #849989

    Thank you for a suggestion.

    I did check those 2 things.

    It is a constraint, and the type of it is "[On] Completion".

    Any additional suggestion?

    Thanks in advance.

    Alex

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

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