July 9, 2021 at 1:27 pm
Are you truncating the target tables first? If not, how are you avoiding duplicates?
Might be simpler to perform a backup/ restore - have you considered that?
July 9, 2021 at 1:32 pm
Hi Phil, I am deleting data from a source after that, so I do not expect any duplicates. The goal is to gather metadata from a few servers in the the one place so backups/restores does not seem to be an option...
July 9, 2021 at 2:30 pm
Metadata, rather than actual data? What sort of metadata?
July 9, 2021 at 2:56 pm
Is it make any difference? These are just statistics about servers collected in diagnostic peruses. For example drive space utilization. Currently I collect that at each server separately. I would like to store that outside of the box, at in one place.
July 11, 2021 at 9:11 am
Is it make any difference? These are just statistics about servers collected in diagnostic peruses. For example drive space utilization. Currently I collect that at each server separately. I would like to store that outside of the box, at in one place.
Going back to your original post, having SSIS dynamically change its column mappings at run time is not possible.
But retrieving data from multiple instances with the same table formats (by looping) is possible.
So if you have (say) five different types of information which you are collecting, in five different tables, and those five tables exist in all of the instances you want to collect information from, you could set up five FOREACH loops, each containing a dataflow for that particular table format.
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply