SQL Server Performance

making backups of dts packages

Discussion in 'General DBA Questions' started by v1rt, Oct 16, 2009.

  1. v1rt New Member

    Good evening folks,
    I would like to backup all the dts packages I have created. I do it by opening it one at a time and saving it as a DTS structure file. However, it's taking forever. It contains dts packages that I started writing back in 2003 and upto present. Can someone please give me an idea how to quickly back them up?
    Thanks,
    Neil
  2. bdondavis New Member

    Neil,
    I have been using DTSBackup 2000 for about three years now. It is available at www.sqltips.com. It allows you to backup the any number packages to a variety of formats with a single command. You can save them to another instance of SQL Server, a structured storage file, or a propietary backup format. It only supports the DTS package format in SQL Server 7 and 2000. I use it to export our packages to structured storage files that are then stored in Visual Source Safe. I hope that helps.
    Don
  3. v1rt New Member

    Thank you so much! That is an awesome tool! [H]

Share This Page