can I use SSIS to get xml documents from a directory and give it as an argument to a stored procedure

• Sarsoura

  Ten Centuries

  Points: 1220

  More actions

  April 29, 2010 at 7:50 pm

  #140096

  can I use SSIS to get xml documents from a directory and give it as an argument to a stored procedure

  I receive xml files from another system but they are not formatted the way that our tables are constructed and we extract only part of the data.

  I have a stored procedure that can read an xml string and extract the required data

  I need to know how can I use ssis to go thru the xml documents in a folder and provide one by one to the stored procedure as an argument and how to schedule such a task to run at the background and process the files as they arrive.

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  May 4, 2010 at 1:34 am

  #1161632

  I can think of a couple different ways to do this..

  The first question I have is, are you passing the content of the XML file to the sproc or just its path and name on disk?

  CEWII