Re: Moving DTS to new server

From: Jeanette (needmoreinfo_at_gmx.de)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 14:59:17 +0200

Hi Andreas,

you can save the DTS packages as "Structures Storage File" and then open
these files on your new database and save it in the SQL Server.

Jeanette

"Andreas" <Andreas@discussions.microsoft.com> schrieb im Newsbeitrag
news:89AB46CE-1B34-4F4A-92CF-4B5C85DABF36@microsoft.com...
> Hi all,
>
> we are moving our database to a new server and I'm wondering how I can
move my DTS packages, too.
>
> Can anyone point me in the right direction?
>
> Thanks
>
> Andreas

Relevant Pages

  • 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: 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: Where are my DTS packages
    ... Your DTS packages in your case are most likely stored in the msdb database. ... If you can get a copy of the old msdb database and restore this you will be ... > SQL Server was lost although the DATA was held on another drive. ...
    (microsoft.public.sqlserver.dts)
  • DTS to run other DTSs
    ... I have created 23 DTS packages to transfer data from an other database ... into SQL server. ... Rather than schedule each of these I would like to ...
    (microsoft.public.sqlserver.dts)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
Loading