Data Conversion

• Mat-1147099

  SSC Enthusiast

  Points: 131

  More actions

  October 18, 2009 at 2:01 am

  #211156

  Hi there

  I have been given a task to take a SQL Server DB and create some output in Excel. Data in the DB are coming through in a single field, which then needs to be split further into other fields depending on the response. e.g.

  100000 washing machine

  100000 hair dryer

  100001 washing machine

  100001 hair dryer

  to:

  100000 washing machine hairdryer

  100001 washing machine hairdryer

  Is there an SSIS function to help do this?

  Many thanks.

• Allister Reid

  SSCrazy

  Points: 2666

  More actions

  October 18, 2009 at 2:27 am

  #1067390

  Dupe post, please see http://www.sqlservercentral.com/Forums/Topic804758-1291-1.aspx