MS SQL Server DTS - unknown (changing) column names in DTSSource

Author

unknown (changing) column names in DTSSource

swasheck@gmail.com

2005-09-28, 11:24 am

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.

Allan Mitchell

2005-09-28, 11:24 am

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

"swasheck@gmail.com" <swasheck@gmail.com> wrote in message
news:1127917675.955619.207640@g43g2000cwa.googlegroups.com:

> 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.

Sponsored Links