>Hi,
>
>I have my dts package as a structured storage file. I plan to save it to my
>server for scheduling. Is there any way that I can remove the previous
>versions from the file to make it smaller before I save it on the server?
>
>Thanx

"Darren Green" wrote:

> In message <872EEA42-FAB4-4B0D-9109-A759CAB57BA7@microsoft.com>,
> MTsang987 <MTsang987@discussions.microsoft.com> writes
> >Hi,
> >
> >I have my dts package as a structured storage file. I plan to save it to my
> >server for scheduling. Is there any way that I can remove the previous
> >versions from the file to make it smaller before I save it on the server?
> >
> >Thanx
>
> Before you save it to the server, you will have to load it. You only
> load one version at a time from a file, so when you save, it is only
> that version. In other words not a problem, as you can have as many
> packages, and versions of packages in one file, but the save is on the
> current version of that package.
>
> There is no way to clean-up files though. Load it and save to a new
> file, or load it, keep it open, delete the file and save again, it will
> re-create the file, but starting again with only the freshly saved
> version.
>
>
> --
> Darren Green (SQL Server MVP)
> DTS - http://www.sqldts.com
>
> PASS - the definitive, global community for SQL Server professionals
> http://www.sqlpass.org
>