import a csv file to table

• Kayal-717623

  Ten Centuries

  Points: 1390

  More actions

  June 19, 2008 at 5:30 pm

  #192950

  Hi everybody,

  I have a csv file which has like 10 columns. I have a table which has 6 fields. I map the first 5 fields of the csv fields to the table. The remaining 5 columns of the file are combined and go into the 6th field of a table which is an XML datatype

  CSV File:

  ----------

  CustomerID

  FirstName

  LastName

  Phone

  Phone2

  FAX

  Region

  SSN

  DLNumber

  DLRegion

  Table:

  --------

  CustomerID

  FirstName

  LastName

  Phone

  Phone2

  AdditionalInfo XML

  So i wanted FAX ,Region,SSN,DLNumber,DLRegion to be stored in the AdditionalInfo XML field. The XML schema has 2 elements - FieldName and FieldValue

  So how do i get the columns from the file into the XML column? What transformation should i use or shud i build the xml in Script Component ? Any help is appreciated.

  Thanks for your time,

  Kayal

  God Bless you.

• pduplessis-723389

  SSChampion

  Points: 10599

  More actions

  June 20, 2008 at 12:41 am

  #831516

  Derived column transformation will allow you to concat the remaining fields into a single field

  ~PD