configuration - SSIS XML DTSConfig update (VS 2005) -


i have dts package xml configuration (.dtsconfig) file have information needs updated every time package runs.

is there way update .dtsconfiguration file?

thanks

ok. haven't found way created script updated elements wanted.

dim xml xml.xmldocument dim xpathtemplate string dim fname string  xpathtemplate = "/dtsconfiguration/configuration[@path='\package.variables[user::{0}].properties[value]']/configuredvalue" fname = "config.dtsconfig" xml = new xml.xmldocument() xml.load(fname) xml.selectsinglenode(string.format(xpathtemplate, "myelement")).innertext = "updated!" xml.save(fname) 

since wanted update 1 field used method.


Comments

Popular posts from this blog

c# - how to write client side events functions for the combobox items -

exception - Python, pyPdf OCR error: pyPdf.utils.PdfReadError: EOF marker not found -