Value Of Parameter

• JM-92548

  Ten Centuries

  Points: 1108

  More actions

  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.

   

• Gordon Meyer

  SSC Enthusiast

  Points: 192

  More actions

  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.