• Its a real shame the script component doesn't expose a columns collection for the Row object. That way you could iterate over the columns very easily and not have to repeat the same code.

    You could do that in a custom component but thats another level of work.

    This is a great solution, I would question the performance of the Find method for the Data Table.

    You might find it quicker to populate a Dictionary object and do the lookup that way.


    Simon Sabin
    SQL Server MVP

    http://sqlblogcasts.com/blogs/simons