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.
Thanks
No comments:
Post a Comment