I just saw some sample code:

Function Main()
DTSDestination("AccountID") = DTSSource("CUSTOMER__")
DTSDestination("AccountName") = DTSSource("CUSTOMER_N")
DTSDestination("GPO") = DTSSource("NATIONAL_C")
DTSDestination("Address1") = DTSSource("ADDRESS_1")
DTSDestination("Address2") = DTSSource("ADDRESS_2")
DTSDestination("City") = DTSSource("CITY")
DTSDestination("State") = DTSSource("STATE_OR_R")
DTSDestination("Zip") = DTSSource("ZIP_OR_POS")
Main = DTSTransformStat_OK
End Function

I have a Function Main() for each column. There are about 40 columns. Its
this a huge performance hit?

How do you think the sample code was created? I guess maybe I can map
multiple columns in one Transformation?

Thanks

Erik

You don't have a Function Main() for each column do you? How are you doing
that?
Do you mean you are using an ActiveX transform?

If yes and the below is your script then Yes it will be slower than simply
using 1 * multi column copy column transform.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Erik" <erikg (AT) pcslink (DOT) com> wrote