I have a database that has a column for the first name and a column for a
last name. I need to use a dts report to merge these two fields into an
additional column in the database. I need to keep all three columns.

Any suggestions?

Hello smrshl,

Use an Active Script transform and have two columns from the source columns
and one from the destination columns. Your Active Script transform will
look simlar to

DTSDestination("Dest Col Name") = DTSSource("SourceColumn 1") + DTSSource("SourceColumn
2")


Make sense?


You could also try doing this in a SourceSQLStatement when defining the datapump
and this would be more efficient. so instead of specifying a table from the
source you do something like

SELECT ................ Col1 + Col2 FROM TABLE

Help?

Allan