Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-14 : 09:22:42
|
| jim writes "I need to design a DTS package that will move data from an OLTP source to an OLAP destination. I also need to combine first, middle and last name columns from a table in the source database into a single column in the destination datbase. How can I do this? Thanks very much." |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-03-14 : 09:38:48
|
| You can do this using an ActiveX transform in the transform data pump task. Select the Transformations tab, select the destination column, click 'New', select 'ActiveX script', click 'Properties', and insert the transform code into the function.Assuming the destination column was named 'fullname', and the source columns were 'first', 'middle', and 'last', respectively, you would have:DTSDestination("fullname") = DTSSource("first") + " " + DTSSource("middle") + " " + DTSSource("Last") |
 |
|
|
|
|
|
DTS Package Designer