I need to capture an XML file which is sent in response to a URL and then import it into SQL. We could save it to an XML text file and then import to sql, don't care what the steps are. Does anyknow know how to do this with SSISAndrew Lindzon

I think that this is similar to what you are looking to do. http://blogs.msdn.com/b/mattm/archive/2009/02/19/read-an-rss-feed-from-ssis.aspx Russel Loski, MCITP Business Intelligence Developer and Database Developer 2008

Hi Andrew, need specifics because in them great details lie... do you also need to initiate the "response to URL" from the SSIS package? Sounds like you are going to consume XML off a WebService. An example of how to import such an XML file: http://geekswithblogs.net/Compudicted/archive/2010/12/21/loading-xml-file-containing-leading-zeros-with-ssis-preserving-the.aspxArthur My Blog

Hi Andrew, Could you please tell us about your current status of this problem? Webservice and RSS feed are the best fit for your problem. do you need more assitance?Thanks Ayyappan Thangaraj UG Lead, Puducherry, http://SQLServerRider.blogspot.com

Still trying to figure out if there is a way to capture an XML file which is sent as a response to a URL into SSIS for import into sql. If you manually put the URL into a browser, the data appears in the browser window. Andrew Lindzon

you can use Script task and write .NET code to read xml file with C# or VB.NET code. just google it and you will find lots of links. http://www.rad.pasfu.com

Still trying to figure out if there is a way to capture an XML file which is sent as a response to a URL into SSIS for import into sql. If you manually put the URL into a browser, the data appears in the browser window. Andrew Lindzon You have to implement HTTP download script. Check here for reference how to do it. After you download the file, you can use the regular XML Source component to process it.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

here is an other example of downloading a file from a website: http://microsoft-ssis.blogspot.com/2011/05/download-source-file-from-website-with.html Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com