<P>Hi all,</P><BR>
<P>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.</P><BR>
<P>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.</P><BR>
<P>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?</P><BR>
<P>Any response will be greatly appreciated. Thanks in advance.</P><BR>

MS Sql Server LazyDBA home page