[dba-SQLServer] Back up DTS local packages

to backup up DTS packages make a backup of the msdb, if you are looking 
to also transfer them to some other server then take a look at DTS backup
http://www.sqldts.com/default.aspx?6,105,242,0,0

note: you still have to do some editing because of location server name 
and such things...

-- 
-Francisco



David Emerson wrote:

> Sorry.  They are in the Data Transformation Services section under 
> Local Packages.
>
> David
>
> At 22/02/2004, you wrote:
>
>> Insufficient info, David... Did you store them all as SQL objects?
>>
>> Arthur
>>
>> -----Original Message-----
>> From: dba-sqlserver-bounces at databaseadvisors.com
>> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of David
>> Emerson
>> Sent: Sunday, February 22, 2004 2:58 PM
>> To: dba-SQLServer at databaseadvisors.com
>> Subject: [dba-SQLServer] Back up DTS local packages
>>
>>
>> I can't seem to find a way to back up my packages in case I need to
>> restore
>> them, or if I want to copy them to another server.  What is the best way
>> to
>> do this?
>>
>> Regards
>>
>> David Emerson
>> Dalyn Software Ltd
>> 25 Cunliffe St, Churton Park
>> Wellington, New Zealand
>> Ph/Fax (877) 456-1205
>
>
> _______________________________________________