Home Forums SQL Server 2005 SQL Server 2005 Integration Services Import excel data to sql server using ssis 2005 with derived column and substring with example RE: Import excel data to sql server using ssis 2005 with derived column and substring with example

  • March 16, 2009 at 9:24 am

    #960342

    Add a Derived Column transformation to break up column two as you need.

    The expression for column 1 will be something like this:

    SUBSTRING([PersonName/FatherName/RationCardNo],1,FINDSTRING([PersonName/FatherName/RationCardNo],",",1) - 1)

    That will extract all the text from position 1 to the position of the first comma, but not including the comma.

    I'm sure that you can work out the others.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.