Rob,

2 ways you can do this.

1. Open the package and save as a Structured Storage File. This would save
the file as a .dts file.
2. Try downloading the DTSBackup utility from www.sqldts.com and this will
allow you to do this with a lot of ease especially if you have many
packages.

Hope this helps...

Mohan

-----Original Message-----
From: Rob Haughian [mailto:rob.[Email Address Removed]
Sent: Thursday, November 27, 2003 10:14 PM
To: LazyDBA.com Discussion
Subject: Scripting out a DTS Package


I want to script out a DTS package from SQL2000, can this be done?

Rob Haughian
Saskatchewan Assessment Management Agency (SAMA)
200 - 2201 - 11th Avenue
Regina, SK, S4P 0J8
Phone: (306) 924-6603



**********************************************************************
This is a commercial communication from Commerzbank AG.

This communication is confidential and is intended only for the person to
whom it is addressed. If you are not that person you are not permitted to
make use of the information and you are requested to notify
<mailto:LONIB.[Email Address Removed] immediately that you have
received it and then destroy the copy in your possession.

Commerzbank AG may monitor outgoing and incoming e-mails. By replying to
this e-mail you consent to such monitoring. This e-mail message and any
attached files have been scanned for the presence of computer viruses.
However, you are advised that you open attachments at your own risk.

This email was sent either by Commerzbank AG, London Branch, or by
Commerzbank Securities, a division of Commerzbank. Commerzbank AG is a
limited liability company incorporated in the Federal Republic of Germany.
Registered Company Number in England BR001025. Our registered address in
the UK is 23 Austin Friars, London, EC2P 2JD. We are regulated by the
Financial Services Authority for the conduct of investment business in the
UK and we appear on the FSA register under number 124920.

**********************************************************************

MS Sql Server LazyDBA home page