Is <DTS:PackageVariable> info required in package? -
09-28-2006
, 07:05 PM
I'm building packages programmatically. I notice that if I open them in BIDS
afterward building them and make a change, my package grows in size
trememdously. An example today went from 60k to 90k. The reason is that
when the package is resaved in BIDS a large section of XML is added with
<DTS:PackageVariable> info.
I read on http://sqljunkies.com/WebLog/knight_...2005/1/13.aspx
why this info exists. My question is, since I'm not creating it
programmatically, do I need to? It seems that it doesn't have to be there
for the package to run correctly.
Am I safe creating packages that do not have this section of info?
Thanks! |