January 5, 2012 at 5:53 pm
Hi
I have a head wrecking scenario which I cant seem to find a solution.
Company I am working for have 200+ word 2010 documents, these are currently word documents and have formatting and icons etc. They are store on their server.
Each document have mergefieds/place holders and currently their applicatio take a subset of these document, updates the mergefields with the results and merges the documents into 1 big report.
Now they are going to Azure and they are pushing that I take each of the 200+ documents and store them in the Azure SQL database.
I have looked at doing a bulk insert of the documents, I have saved the DOCX files as XML, OpenXML, XPS and then into XMLDocs, OpenXML docs, streamreaders and storing them in a table in the database in XML fields,varchar(max) and nchar(Max).
Ther is no problem storing them, but when I retrieve the record and the field which has the word document converted and then create a new word document from this field it never works out into the format of the original document.
Anyway, I am open to ANY suggestion to get this working.
I can't physically store the documents on a server in Azure and Ineed to be able to update the value of the mergefield and join the documents together.
Many thanks
January 5, 2012 at 6:01 pm
duplicate post. no replies please.
Original post: http://www.sqlservercentral.com/Forums/FindPost1231214.aspx
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply