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

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Update XML Files in SharePoint Library

Author  Topic 

Starting Member

28 Posts

Posted - 2015-01-21 : 12:11:58
I have a SharePoint document library that stores a 4 XML files. Three of them are relatively small, but one could grow to be quite large (potentially 10,000 + records)

These are to be mimics of SQL “conversion” type tables to be used by a web app if the SQL server is ever down. As a result, the XML files will need to be updated daily to reflect any changes to the SQL tables.

The web app was (is still being) written by my ex-manager, who has left the company but is wrapping up this project.

I need to use automate refreshing these files daily. I assume there is some way to use SSIS. I have the SQL queries that will pull the data from the four tables and format into XML. What are my options here? Am I limited to simply deleting the existing files each day and then uploading the new tables? I think I can figure out how to delete the files, as I have done this before in a different scenario (using a script component). But I am still figuring out how to upload the new files to the library.

Or, is there another way?

I have very little experience with XML files and script components and in any previous experience, I had my boss there to help me and point me in the right direction. I really don’t have a local resource to reach out to for help. I could contact my ex-boss, and have for other issues regarding this project, but would prefer to not have to keep using him as a resource.

Any help would be appreciated.


- Advertisement -