Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

creating a package to import data from excel file into sqlserver table Expand / Collapse
Author
Message
Posted Monday, March 24, 2014 9:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 9, 2014 2:07 PM
Points: 17, Visits: 82
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.
Post #1554097
Posted Monday, March 24, 2014 11:06 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:38 AM
Points: 2,126, Visits: 1,470
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
Post #1554147
Posted Tuesday, March 25, 2014 2:12 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 9, 2014 2:07 PM
Points: 17, Visits: 82
Yes all the 3 files are identical means they have same columns and same data type.
Post #1554671
Posted Wednesday, March 26, 2014 2:48 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:38 AM
Points: 2,126, Visits: 1,470
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
Post #1554827
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse