I need to be able to set the DTSDestination column dynamically using a variable for the column name. Here is the code I am using:
strColName = cstr(DTSSource("ColName"))
DTSDestination(strColName ) = DTSSource("QVal")
I am getting the error "Invalid procedure call or argument: 'DTSDestination'". I'm sure that I am just missing something.