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