How to divide one column data into different columns data in excel file

• venkat113

  SSC-Addicted

  Points: 420

  More actions

  November 13, 2011 at 9:28 pm

  #262662

  Hi

  This is venkat I am in ssis Any one solve this problem

  i have one excel file all data in one column only how to sending that data different columns in sqlserver database using ssis

  That excel file like this

  Source Excelfile Destination sqlserver Database Emp Table In that

  Only one columnname :emp one column :empid empname

  1 1 venkat

  2 2 hari

  3 3 naresh

  4 4 Jakkam

  venkat

  hari

  Naresh

  Jakkam

  Any one Help me

• chris_hurley

  SSC-Addicted

  Points: 479

  More actions

  November 14, 2011 at 4:19 am

  #1407050

  You could use a derived column transform after your excel datasource task.

  Use substring functions inside the derived column task to split the fields using nth occurences of the literal spaces in your data rows.