 | |
DTSBackup 2000
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DTSBackup 2000 -
11-10-2005
, 08:36 AM
#2
| |||
| |||
|
|
Hi, I am in the process of archiving my DTSs to Structured Storage File format. I did a test: 1) save them manually 2) save them using DTSBackup 2000 utility Strangely, the resulting files are not the same size... The .dts saved manually are about 20% bigger. Should I worry? |
DTSBackup is produced through the object model. The object model throws
the layout information away, by MS design. So manually saving stuff is
better if you like layouts, but obviously manual. The DTB format in DTS
Backup does not use the object model, so it keeps the layout, but is not
compatible with DTS.
Darren
http://www.sqldts.com
http://www.sqlis.com
#3
| |||
| |||
|
|
fleo wrote: Hi, I am in the process of archiving my DTSs to Structured Storage File format. I did a test: 1) save them manually 2) save them using DTSBackup 2000 utility Strangely, the resulting files are not the same size... The .dts saved manually are about 20% bigger. Should I worry? Saving manually retains the layout information. The DTS format used by DTSBackup is produced through the object model. The object model throws the layout information away, by MS design. So manually saving stuff is better if you like layouts, but obviously manual. The DTB format in DTS Backup does not use the object model, so it keeps the layout, but is not compatible with DTS. Darren http://www.sqldts.com http://www.sqlis.com |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.