sql server dts: I was wondering if it is possible to do something like this:

Dim ColName = "username"
Dim SomeVar

SomeVar = DTSSource(ColName)


Does anyone know if it is?

Thanks in advance for your help.

Where do you want to do this?
What are you going to do with it is you can do it?

Surely you would not want to assign the name from a variable like this
so perhaps a Global variable would be more appropriate?


I will presume the DataPump task. This would seem to work fine.


dim ColumnName

ColumnName = "ContactID"


DTSDestination("ContactID") = DTSSource(ColumnName)


Main = DTSTransformStat_OK


Allan





[quoted text, click to view]