February 27, 2012 at 8:11 pm
I am an accountant really interested in databases I lern from this site every day.
My question is the following if you can provide me with articles or hints to continue with my investigation.
I have several clients each one with a different kind o f version of SQL most of them wiht SQL SERVER EXPRESS, I have to collect data from them and send it to my own server with SQL SERVER EXPRESS WITH ADVANCED SERVICES 2008
I was thinking that each one sends a txt file to my own ftp and collect it with Integration Services every day I have to figure out that EXPRESS editions don´t have SQL AGENT or I was reading to do that with SERVICE BROKER.
Is that right or is a better and secure way to do that every day.
THANKS A LOT IN ADVANCE
IGNACIO
February 28, 2012 at 1:26 am
Basically I think you have two options.
One way would be starting your SSIS packages using the dtexec command line utility and use Windows Task scheduler to schedule them. That's probably the easier option.
The alternative is as you rightly mentioned using service broker. Service broker has the advatage that it works asynschronously and even then one of the machines is offline, the mesdsages will still be delivered, just a little later. The disadvantage of using service broker is that it's quite complex to set up and troubleshooting can be a really hard. Trust me, I just spend a whole day last week solving a broker issue.
You can find a pretty good article about using SSB with SQL Express here:
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply