Right now all of my XML Packages query my database in order to create the xml they will transform.
This causes a lot of needless query activity on my database because every time someone requests a page load it has to run out to the database to get data that simply doesn't change all that often.
I would like instead to use data stored in a separate XML file as the datasource, feeding it to the XSLT for transformation. This would allow me to periodically run a stored procedure that outputs XML-formatted data and update my saved XML file while reducing the load on my database.
I've searched the old forums and keep coming up with broken links. http://forumarchive.vortx.com/threads/6712-Loading-an-XML-file-into-an-XML-Package.html looks like it may have some useful informatin, but it returns a 404.
Has anyone else succeeded at doing this? I appreciate any guidance you can provide.