sql server dts: Does anyone know if there is a way to use a variable to refer to a column
name in a script component tranformation? For example:

Row.Column1 = "Test"

What I'd like to do (pseudo code):

strColumn = "Column1"
Row(strColumn) = "Test"

I'd even be ok if I could use ordinal position. Any ideas?

Thanks in advance.

Hello sqlboy2000,


Why do you need to do this is my question?

What logic do you need to do to make it so that you dynamically determine
the column name?




Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]