In the activex of data pump task, I need to apply a same function to
every source column to get destination column. Is it possible to write
a for loop to apply the same function to every source column so that I
don;t have a repeat the following code for every column.

DTSDestination("col1") = Applyfunction (DTSSource("col1"))

thanks
PM

Try (untested):

For Col = 1 To DTSDestination.Count
DTSDestination(Col) = Applyfunction (DTSSource(Col))
Next

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom (AT) cips (DOT) ca
www.pinpub.com

"pm" <mittal.pradeep (AT) gmail (DOT) com> wrote

Yes it works.

thanks

Tom Moreau wrote: