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 2005 Forums  SSIS and Import/Export (2005)  provide xml document thru ssis as an argument sp

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