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.
Comments
Post a Comment