Click here to Skip to main content
15,304,161 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...


Thanks
Nithya
Posted
Comments
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

Hi,

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.
   
Comments
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