Script Task

• Lucky9

  Default port

  Points: 1470

  More actions

  July 20, 2012 at 11:01 am

  #264120

  I have to declare a variable in the script task and it should create a newid()

  for each execution..

  Could someone help how to create a variable and generate the newid inside a script task

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  July 20, 2012 at 11:32 am

  #1515675

  Please explain what you are trying to do. Newid() is a SQL thing and a script task is not. Combining them can be done, but not without trips to the server.

  ---

• Lucky9

  Default port

  Points: 1470

  More actions

  July 20, 2012 at 11:38 am

  #1515678

  I am sorry but am trying to insert the newid value into the column in a sql server table....