[dba-SQLServer] Back up DTS local packages

David Emerson davide at dalyn.co.nz
Mon Feb 23 15:21:33 CST 2004


Thanks.

At 23/02/2004, you wrote:
>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
>>
>>
>>_______________________________________________
>
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>




More information about the dba-SQLServer mailing list