Re: Saving/Moving DTS packages

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 18:05:19 +0530

Hi,

I have several DTS packages I'd like to archive somehow. How can I do so?

Take the backup of MSDB database. or have a look into the below link

http://nicksumner.com/software/SQL_Xf1/SQL_Xf1.htm
http://www.databasejournal.com/features/mssql/article.php/1462601

How do I transfer DTS packages from one server to another?

http://www.sqldts.com/default.aspx?204

And, how do I transfer database diagrams from one server to another, or save
database diagrams (for archiving purposes, for example?)

http://www.mssqlcity.com/FAQ/TranMove/MoveDiag.htm

Thanks
Hari
MCDBA

"Mario Splivalo" <majk@fly.srk.fer.hr> wrote in message
news:slrnc65hnt.b3u.majk@fly.srk.fer.hr...
> I have several DTS packages I'd like to archive somehow. How can I do so?
> How do I transfer DTS packages from one server to another?
>
> And, how do I transfer database diagrams from one server to another, or
save
> database diagrams (for archiving purposes, for example?)
>
> When I backup and then restore database, i don't get database diagrams.
>
> Mike
> --
> "I can do it quick. I can do it cheap. I can do it well. Pick any two."
>
> Mario Splivalo
> msplival@jagor.srce.hr

Relevant Pages

  • Re: Need help with DTS Package Maintenance
    ... You can create DTS packages in VB, ... > source Interbase Database and I make a SQL Server connection to the target ...
    (microsoft.public.sqlserver.dts)
  • Re: Standard Method for Importing/Exporting to DB
    ... the database name, server name, and filename+fullpath. ... and also exporting to CSV files. ... everything from DTS packages to Crystal Reports are used. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How do I distribute DTS Packages with my Application Database?
    ... BTW, is there any way to store a DTS package in a specific *database*, as ... And if not possible with SQL Server ... > Number of ways but undoubtedly the easiest is as a Structured Storage file ... >> distribute my DTS Packages? ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server 2005 DTS problem: "Error 21776: General Error"
    ... restoring on 2005 from the 2000 backup files has worked flawlessly for this ... stuck with the DTS packages. ... once we renamed the server we had problems. ... it's not related to the number of objects in the database). ...
    (comp.databases.ms-sqlserver)
  • Re: restore DTS from a backup
    ... What I would do is to install a temporary SQL Server instance and restore ... the msdb database to this instance. ... Since the DTS packages are saved in this ...
    (microsoft.public.sqlserver.setup)