Click here to Skip to main content
14,929,655 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have data in the Cell range B61:F91.
How do I load these data into SQL table using SSIS?
Posted
Comments
Rajesh Varma Buddaraju 20-Oct-14 3:13am
   
This will also helps to you, https://www.simple-talk.com/sql/ssis/moving-data-from-excel-to-sql-server---10-steps-to-follow/

1 solution

Hi, I can tell you the procedure.
1. Import the data from excel to a temparary table in sql server. Using excel datasource to sql
2. write queries to import the data from temporary table to their actual tables using the necessary joins. Execute the queries using script task.
3. Once it is completed. Delete the temporary table from sql server.
   
Comments
Member 11165845 20-Oct-14 3:24am
   
Can u give me an example of the Script task for the above range(B61:F91)?
For example, if I have a any term called 'Registration Number' in the cell "B60" and 'User Name' in the cell "C60" then i need to load the data from B61 and C61 till some word occurs in any cell as a ending criteria(or till any word like "Department" occurs in the "Column B" in any row)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900