I have a SQL Server INtegration Services package that calls a VB Script. The Script loads and XML document from the C drive. It then modifies the XML document. It then saves the document back to the C Drive.
I have a loop that calls the VB Script multiple times. The first time the XML document is successfully modified and written to the hard drive. The second time, I recieve an error when loading the document because the document is still locked by the first run through the script.
I need someone who can help me figure out how to load or save the document differently so that the script will successfully loop.
## Deliverables
I have attached 3 items
1. A scren shot that shows how the script is used by Integration Services.
2. The XML file that I am modifying.
3. The script that modifies the XML file.