Home Forums SQL Server 2005 SQL Server 2005 Integration Services creating a package to import data from excel file into sqlserver table RE: creating a package to import data from excel file into sqlserver table

  • March 26, 2014 at 2:48 am

    #1700176

    raj.prabhu001 (3/25/2014)

    Yes all the 3 files are identical means they have same columns and same data type.

    Good, that makes things a lot easier! Basically you are going to need a For Each Loop container in the Control Flow that contains a Data Flow Task. The Data Flow task is where you specify how the data in the Excel source files is mapped to your destination SQL Server table.

    Have a look at this step-by-step guide: http://bi-polar23.blogspot.co.uk/2007/08/loading-multiple-excel-files-with-ssis.html

    For a wider overview of SSIS, have a look at Andy Leonard's 'Stairway to Integration Services' articles here on this site:

    http://www.sqlservercentral.com/stairway/72494/

    Also, I recommend getting yourself a book (or two) on SSIS.

    Regards

    Lempster