SSIS-ETL-从许多服务器传输表/数据库？ [英] SSIS - ETL - Transfer tables/databases from many servers?

问题描述

我有6-7个相同的数据库（几乎）。我想将这些服务器的每个EACH表中的数据复制到一个服务器的对应表中。即，多个源和一个目标服务器。所有服务器具有不同的IP。我该怎么做？ for循环是否适合于此。如果是，那是什么好方法呢？

I have 6-7 identical databases (almost). I want to copy the data from some of the tables of EACH of these servers into the corresponding table of ONE server. That is, multiple sources and one destination server. All the servers have different IPs. How do I do this task ? Would for loop be appropriate for this. If yes, then what would be a good way to do it ?

我可能会执行一些Transform。目前尚不确定。为了安全起见，我想使用SSIS。

I might perform a bit of Transform. Not sure as of now. To be safe, I want to use SSIS.

推荐答案

这里概述了如何设置FOR EACH LOOP来遍历数据库，只要表是相同的。

Here is an overview of how you can set up a FOR EACH LOOP to loop through the databases, provided the tables are indentical.

不过这太矫kill了。

It is overkill though.

SSIS循环在主程序包中的连接字符串列表，并分别执行两个其他程序包连接字符串

这篇关于SSIS-ETL-从许多服务器传输表/数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！