Post reply

Validation Task / Step

  • November 16, 2010 at 10:30 am

    #1251466

    I think the easiest way to do this is to perform some sort of check (either with the execute SQL task or with a script task that validates the connection, as you proposed yourself), but the important point here is to store the result in a variable. Preferably a boolean variable.

    Then, after the check, use a precedence constraint with an expression. If you do not know what that is, double click on a green arrow in the control flow. You'll get an editor window where you can configure your precedence constraint.

    Anyway, construct a precedence constraint so that you only truncate when the connection exists.

    If you have more questions, let me know.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 16, 2010 at 6:28 pm

    #1251663

    Thanks for the response. Haven't got back to it but i do follow your suggestion. I'll let you know how i make out.

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

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