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
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
