May 5, 2010 at 10:07 am
I am receiving small xml files thru form post. Those are saved thru a prog to a directory. I am thinks of receiving those into a service broker queue and then reading those message and process them using sp is that better or leave it as is and use ssis to go thru the files and execute a stored procedure
May 5, 2010 at 2:00 pm
What kind of volume are you talking about?
Is the system keeping up currently?
May 5, 2010 at 3:12 pm
around 600 xml files each day of size 2 k each
May 5, 2010 at 3:37 pm
Trade offs:
SSIS packages is much easier but has to be scheduled. If it runs every 30 minutes that would mean your xml packages could be 30 minutes stale. You could schedule the job to run every 10 seconds to address that. Something to keep in mind. It is easy to see if it's working: "is the job running successfully?"
Service Broker is more complex. But the data gets into your database usually within seconds of it being sent. Harder to tell when it isn't working without some other monitoring process.
If you've never done either of these before, I would recommend SSIS as it will be 1/10th the headache of Service Broker.
May 5, 2010 at 5:03 pm
Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply