Post reply

Value Of Parameter

  • September 7, 2006 at 1:00 pm

    #119449

    I created a variable of type int with a value of 1.

    created a new sql task:

    select max(id) from tbl_1 as id

    In the result set I map this id to the variable.

    But when I stop debugging the variable still has a value of 1.

    Is it just not refreshing or am I mssing a step.

     

  • September 10, 2006 at 11:45 am

    #659540

    Hi,

    Could it be the syntax of your code should be select max(id) as id from tbl_1? I think you are setting the table alias 'id' to the SSIS variable rather than the variable alias.

     

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

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