Saving packing to reduce file size

#1

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
package manually ?

#2

Hello rmcompute,

Quote:

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 package manually ?

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)

#3

Thank you.

"Darren Green" wrote:

Quote:

Hello rmcompute,

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 package manually ?

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Saving packing to reduce file size

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Saving packing to reduce file size - 06-28-2006 , 12:29 PM

Re: Saving packing to reduce file size - 06-28-2006 , 01:33 PM

Re: Saving packing to reduce file size - 06-28-2006 , 05:13 PM