all groups > sql server dts > june 2006 >
You're in the

sql server dts

group:

Saving packing to reduce file size



Saving packing to reduce file size rmcompute
6/28/2006 10:29:02 AM
sql server dts: I created a package with is used several times in another package. Because
of the number of times I changed the subordinate package, the file size grew
quite large. To reduce it, I called up the subordinate package and did a
save as newfilename (with the same package name). I then deleted the old
subordinate package and renamed newfilename with the old subordinate package
name. The size of the file was reduced significantly, but now I have to go
into all other packages that use this subordinate package and re-select it.
It seems that the package ID changed. Is there any way to do this
automatically rather than go into each package and change each subordinate
Re: Saving packing to reduce file size rmcompute
6/28/2006 3:13:01 PM
Thank you.

[quoted text, click to view]
Re: Saving packing to reduce file size Darren Green
6/28/2006 6:33:24 PM
Hello rmcompute,

[quoted text, click to view]

I don't belive there is any way to stop the ID changing.

Make the Execute Package Task name dependent only
(http://www.sqldts.com/default.aspx?216

AddThis Social Bookmark Button