Concatenate string in DTS package

• Dan McGorty

  SSC Enthusiast

  Points: 104

  More actions

  September 22, 2005 at 4:40 am

  #165334

  I'm trying to concatenate the value of 2 varchar fields in the DTS source to a single field in the destination. Example: Select Lname + ', ' + Fname as Name. I'm getting an error that the + token is invalid. It works fine in query analyzer. What am I missing?

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  September 22, 2005 at 6:09 am

  #592157

  If you are writing the code as part of an ActiveX script, the & character is used to concatenate strings, not + (just to keep you on your toes)!

  ---

• Dan McGorty

  SSC Enthusiast

  Points: 104

  More actions

  September 22, 2005 at 10:46 am

  #592333

  It was in a "copy column" task. I had tried using the & character also but it failed. I think the problem might be that my source is a DB2 table and the SQL must not support concatenation with its fields. I'm not familiar with the ActiveX script, but maybe I'll look into that and see if I can get it to work that way.  Thanks.

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  September 22, 2005 at 1:04 pm

  #592365

  Dan,

  You could import into a "staging" table with separate name columns, then concatenate as you move the data from there to your "real" table.

  Greg

  Greg

• Dan McGorty

  SSC Enthusiast

  Points: 104

  More actions

  September 27, 2005 at 4:10 am

  #593212

  Thanks Greg. That's the solution I'll use!