Adding a prefix to data in SSIS

• SQL learner22

  Default port

  Points: 1487

  More actions

  October 11, 2017 at 9:51 am

  #340746

  how can i add the prefix MO at end of the Data before I send to a destination which is excel spreadsheet? 
  Thanks. 

  Current Data 

  
  what Data should look like after the Prefix 
  

• Thom A

  SSC Guru

  Points: 99126

  More actions

  October 11, 2017 at 9:57 am

  #1963211

  Use a Derived Column transformation in your Data Flow before your Destination Node.

  P.s. Your sentence is a a bit conflicting; "prefix MO at end of the Data". A prefix is at the start of the data (as you showed), not the end. 😉

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• SQL learner22

  Default port

  Points: 1487

  More actions

  October 11, 2017 at 1:33 pm

  #1963256

  I used the [Derived Column].SampleRegID + "-MO" . thanks.