xml file creation and auto updation from sql database

• prashantgavkar

  Newbie

  Points: 7

  More actions

  August 21, 2013 at 11:43 pm

  #278929

  Hi,

  we are trying to generate xml file to a particular location from sql server 2008 tables and we want to auto update that xml file on a particular time intervals at that location only (as sql data updated we need auto updation of that xml file).

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  August 22, 2013 at 7:51 am

  #1643927

  I'd probably do this with SSIS and put the process in an agent job that runs on set schedule.

  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