Click here to Skip to main content
15,796,456 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi frnds...

I am new to this work.. Now i have to do the migration work.. i.e. i have to import the datas from excel and move the datas to our table according to our structure... the excel datas structure may be different... how to use ssis to migrate the datas... i have no idea in ssis... could u someone briefly explain me...

Herman<T>.Instance 18-Apr-12 4:41am    
why use ssis? You can use the management studio to import the excel files in a table. Then you can migrate the data to the desired structure.
nithibs 18-Apr-12 5:06am    
i can import the excel file through management studio.. but using management studio i can't insert the 1 lakhs records...

1 solution


You can follow given steps.
1.Take a data flow Task in Control flow from tool box.
2. Double click on dataflow task and add Excel source.
3. Fill Excel Source with Connection which ultimately will take schema from existing excell sheet.
4. Use the Data Conversion Transformation if you want to change data as per your DB schema.
5. Use ADO.NET/OLEDB Destination and map the relavant fields.
Share this answer
nithibs 18-Apr-12 23:42pm    
Hi... Thanks for your answer... ill do the task and get back to u if i have any doubt... Thanks once again...

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