Import excel data to sql server 2005 using SSIS2005

  • I had excel file A.XLS

    SNo PersonName/FatherName/RationCardNo

    1 rajaiah,s/o anjaiah,R100

    2 RAMARAO,s/o Somaiah,R101

    3 Laxmaiah,s/o anjaiah,R102

    4 anjaiah,s/o ramaiah,R103

    I want to transfer the data from excel file to sqlserver 2005(PersonDet table)

    using with separate comma using ssis2005

    In sql server 2005 I had PersonDet table

    PersonDet

    ---------

    SNo

    Personname

    FName

    RCardNo

  • Basically, you need 2 connections (1 for excel, 1 for sql), 1 data flow task & 1 derived column transformation (within data flow task) that splits the value into multiple columns using FINDSTRING/SUBSTRING functions. Or you can write an SQL Query for excel source (in data flow task) that splits the value into multiple columns.

    --Ramesh


Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply