SQL迁移工作 [英] Migration Work in SQL

问题描述

朋友们...

我是这项工作的新手..现在我必须进行迁移工作..即，我必须从excel导入数据，然后根据我们的结构将数据移动到我们的表中……excel数据结构可能有所不同. .如何使用ssis迁移数据...我在ssis中一无所知...有人可以简要向我解释一下...


谢谢
Nithya

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

推荐答案

您可以按照给定的步骤进行操作.
1.从工具箱中获取控制流"中的数据流任务.
2.双击数据流任务并添加Excel源.
3.用连接填充Excel Source，最终将从现有的excell工作表中获取架构.
4.如果要根据数据库架构更改数据，请使用数据转换转换.
5.使用ADO.NET/OLEDB目标并映射相关的字段.

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.

这篇关于SQL迁移工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！