Post reply

creating a package to import data from excel file into sqlserver table

  • March 24, 2014 at 9:48 am

    #284919

    Hi all,

    I am new to SSIS and i want to create a package which will upload data from 3 seperate excel files into

    the sqlserver table and then it should fire one update sql on it.

    PLease giude me the steps to do so.

    Thanks.

  • March 24, 2014 at 11:06 am

    #1699621

    What research have you done so far?

    Unless your source Excel files are structured identically, you are going to find it difficult to import the contents of those files into a single table.

    We need more information before we can help. Are your 3 Excel files identical in structure?

    Regards

    Lempster

  • March 25, 2014 at 2:12 pm

    #1700051

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

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

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