Running an SQL Task (SSIS) by using package vars problem!

• Amann Ottmar

  Old Hand

  Points: 339

  More actions

  May 1, 2006 at 11:34 pm

  #172309

  Hello together,

  I'll change a package variable, without writing a SQL function or procedure. Is there a way to get this var into my script like

  SET @[namespace::var]= 'something'

  I'd used the SQL-Task from the toolbar.

  Thanks,

  Ottmar

• Jim Tottser

  SSC Enthusiast

  Points: 165

  More actions

  May 3, 2006 at 7:04 am

  #635580

  have you tried to use an expression to calculate the sql script?