Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  use ssis to provide xml document to sp

Author  Topic  Nader Starting Member 41 Posts Posted - 2010-04-29 : 21:56:52 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.