创建将数据从MYSql传输到Sql Server的SSIS包的步骤 [英] Steps to create SSIS package which will transfer data from MYSql to Sql Server

问题描述

大家好，

我不知道如何使用SSIS包，在查看了一些链接后，我知道了如何使用它，但是我仍然无法做到将数据从Mysql传输到sql server.

如果有人可以帮助我找出创建SSIS包以将数据从MYSQL迁移到sql server的步骤，我将不胜感激

谢谢，

Hello Everyone,

I don''t know how to use SSIS package, After looking at some links i came to know how to use that but still i am not able to do that for transferring data from Mysql to sql server.

I would appreciate if someone could help me to find out steps for creating SSIS package for migrating data from MYSQL to sql server

Thanks,

推荐答案

1)创建程序包
2)在控制流中执行数据流任务
3)双击数据流，然后拖动oledb源
4)在源代码中添加表
5)获取oledb目标并连接目标表

1)create the package
2)take dataflow task in the control flow
3)double click the dataflow then drag the oledb source
4)add table in the source
5)take oledb destination and connect destination table

这篇关于创建将数据从MYSql传输到Sql Server的SSIS包的步骤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！