SSIS - ETL - Transfer tables/databases from many servers? -


i have 6-7 identical databases (almost). want copy data of tables of each of these servers corresponding table of 1 server. is, multiple sources , 1 destination server. servers have different ips. how do task ? loop appropriate this. if yes, way ?

i might perform bit of transform. not sure of now. safe, want use ssis.

here overview of how can set each loop loop through databases, provided tables indentical.

it overkill though.

ssis loop list of connection strings in master package, executing 2 other packages each connection string


Comments

Popular posts from this blog

c++ - Function signature as a function template parameter -

algorithm - What are some ways to combine a number of (potentially incompatible) sorted sub-sets of a total set into a (partial) ordering of the total set? -

How to call a javascript function after the page loads with a chrome extension? -