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
Post a Comment