July 17, 2012 at 7:52 am
Hi All,
We are intending to harvest data on a daily basis from 500 remote sites. Its likely to be under 1000 rows per site per day. Any opinions on whether SSIS or service broker would be best? Which one would be more maintenance overhead?
Thanks,
Terry
July 17, 2012 at 8:40 am
From my perspective a once a day process says SSIS. Are the imports the same for each site? If they are then it is on package that has a for each and a data flow where the for each iterates over the remote servers so you can change the source connection to point to the different locations. I'd store the Source connection list in a table (you could use a text file as well, and then if you need to add/remove/modify a location you just make the change in the Source connection list and the process is changed.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply