DTS
Adding new destination columns.

Can you using the DTS designer add new columns to the Destination?
I want to combine fields from the Source into some new Destination
columns.


Thanks

Hello paulhux174 (AT) hotmail (DOT) com,


Do you actually want to ADD/CREATE new columns or do they already exist in
the destination and they do not have a 1:1 matching column in the source?

For the latter then you can do this in a few ways.

1. In your SourceSQLStatement you can do something like this

SELECT
FirstName,
LastName,
FirstName + ' ' + LastName as FullName
....
FROM
...

2. You can also do this in an Active Script transformation


DTSDestination("FullName") = DTSSource("FirstName") + " " + DTSSource("LastName")



Hope this makes sense.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com