Neo
Reputation: 16219
insert data from more than one excel sheet of one file into table using SSIS?
i have one excel file that contains a1 to a5 rows with values now a6= sum(a1:a5)
I want a6 value to be inserted into database using ssis package
How can i do mapping ;(
Upvotes: 0
Views: 483
Answers (1)
Daryl Wenman-Bateson
Reputation: 3939
If you always want to ignore the first 5 rows and take the value in the 6th, use the SQL Server Destination component and set the first row and last row to insert as explained by Jiqin Ma Import single cell
Upvotes: 1
Related Questions
- SSIS: Insert multiple Excel files with same format but different file name to multiple database table destinations based on the Excel filename
- Insert record into Multiple table from single excel sheet using SSIS package
- Is there a simple method to import data from multiple excel flies to SQL including names of the files using SSIS?
- How to import multiple excel sheets in an excel source to SQL using SSIS?
- Load Excel Data from Multiple Excel Files into Sql Server Tables
- Import each Excel File to a new SQL Table using SSIS
- Batch Inserting from Excel into SQL Server
- How do I load an Excel file data into multiple tables using SSIS package?
- How to import Excel Document Data, Sheet by Sheet, into SQL tables
- Importing data from excel to multiple tables in Sql Server database