Migration Work in SQL

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

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 17-Apr-12 22:17pm

nithibs

Add a Solution

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Bhoopendra Pratap Singh · Accepted Answer · 2012-04-17T23:29:00

Solution 1

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.

Posted 17-Apr-12 23:29pm

Bhoopendra Pratap Singh

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