Post reply

how can i get the value?

  • October 24, 2011 at 5:31 am

    #245649

    I'm just increment a column value one by one....for example 1,2,3,....100000..through script component...i need to the get the last column value from the script component and i have to insert that single value alone into another table...how can i do that?

    Thanks,
    Charmer

  • October 24, 2011 at 6:35 am

    #1398636

    You should be able to do this using an SSIS variable, passing it to the script using the ReadWriteVariables property of the Script task, updating it within the script and then creating an execute sql task after the script task to insert the variable value into your sencond table.

    Regards

    Daniel

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

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