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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Update XML Files in SharePoint Library
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

paulkem
Starting Member

28 Posts

Posted - 01/21/2015 :  12:11:58  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000