RE: SAVED DTS package file with multiple versions

As for automating the opening and saving as new process, I'm sure there
are some homemade that have been created. Try www.sqldts.com. They
have several helpful scripts for DTS.

To eliminate this from happening in the future, what I do is to select
"Save As" from the Package menu within the DTS designer instead of just
hitting the save button.

What I do then is:
1. Locate and highlight the existing file on disk and delete it (from
the Save AS window).
2. Click SAVE.

This will just save your most recent change.

Good Luck!

Gordon Radley

-----Original Message-----
From: Benbart
[mailto:mssqldba-ezmlmshield-x70284361.[Email address protected]
Sent: Wednesday, April 27, 2005 6:40 PM
To: LazyDBA Discussion
Subject: SAVED DTS package file with multiple versions

Hi all, 
I have a DTS package that was saved with multiple versions which is
why the file had grown for up to 5MB in size, 10 of those will give me
50MB and who knows maybe some of them will be 10MB in size. 
Anyway, at the moment, I can get rid of the other versions and
basically reduce the size of the DTS package from 5MB to 400KB by
opening the DTS package and then re-saving them using a different name,
which in theory gets rid of the other versions and start with a new
version. If I have 100 of those DTS packages, I will be manually opening
and re-saving for the whole day probably. 
Can anyone suggest of whether these steps can be scripted in any way?
Are the versions saved with the DTS file by default everytime I re-save
a DTS package? Is there anyway that I can turn this off? 
Any response will be greatly appreciated. Thanks in advance. 

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]

MS Sql Server LazyDBA home page