Post reply

Precedence expresion question

  • December 15, 2006 at 2:46 pm

    #170777

    Hi,

    I have a SSIS package that has one SQL task that retrieves the value of a flag and stores it on a variable varStatus. But when I use the expresion @varStatus==" " (status retrieved is one space) as a precedence constrain, the process does not advance to the next task.

    Is the syntax wrong for what I'm trying to do?

    Thank you

  • December 18, 2006 at 2:59 am

    #678584

    Hi,

    I think your syntax is correct so maybe it is the result from the SQL Task. Try testing the precedence by using the most basic SQL you can in the SQL Task. ie

    Select ' ' As Status

    Regards

    Daniel

  • December 27, 2006 at 7:10 am

    #680075

    Thank you, but I found my problem:had to create another variable to store the value I wanted to compare to, and use the expression @varStatus == @constCheckStatus. This did the proper evaluation and advanced or failed depending on the value retrieved.

    Thanks.

     

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

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