December 8, 2009 at 10:36 am
I have a SQL 2005 server at a central location. It's connected to a couple hundred remote SQL Servers (linked). The remotes are a mix of SQL2000 & SQL2005. Everything is connected over a VPN. I need to move (a small amount of) data from the remotes to the server on a daily basis. I've figured out how to do this very nicely using SSIS, doing a "PULL" from the server. I've got some of the "suits" telling me that PULLING the data might be some sort of violation of our business agreement. I think I'll get this worked out with them. BUT if I can't, any ideas out there as to how I might implement a PUSH solution, from 200 remote sites, to a central server, using SSIS?
.
December 9, 2009 at 6:35 am
I'm sure if you have the access to the remote servers then you could setup SSIS, dts on 2000, at the remote sites and "PUSH" the data to the central system. In reality you are doing the same thing, except trying to do PUSH will be a management nightmare compared to pulling from the central server.
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