Foreach loop with Script Task

• xavendano

  Mr or Mrs. 500

  Points: 552

  More actions

  July 8, 2009 at 10:18 am

  #207899

  Greetings,

  I have a foreach loop that is fed from a query. This consultation has a single field named "ID" and resulset type of object it returns is called DATA.

  Within the foreach loop desire to manipulate the ID, using VBSCRIPT to this task from a script. How can I set this? How can I manipulate the resultset inside the loop?

  Public Sub Main ()

  '

  'Add your code here

  '

  Dts.TaskResult = Dts.Results.Success

  ¿¿¿MsgBox (Dts.Variables (0). Value)?

  End Sub

  Thanks !!!

• niall.baird

  Hall of Fame

  Points: 3468

  More actions

  July 8, 2009 at 4:44 pm

  #1022042

  Create a variable in your package (intID)

  In your script

  Dts.Variables("intID").Value = Cint(Dts.Variables("intID").Value) + 1 ' or however else you want to manipulate it.