Re: DTS packages on new SQL Server

From: Doug Stiers (stiers_at_email.com)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 15:23:08 -0500

OK, I saved a package to a .dts file. How do I import/execute that file?

Thanks,
Doug

"Geoff N. Hiten" <SRDBA@Careerbuilder.com> wrote in message
news:Ormd6IFDEHA.3568@tk2msftngp13.phx.gbl...
> They are stored in the MSDB database, but moving that database is always
> trickey. You can load the DTS packages into Enterprise Mangler and save
> them to the file system. You can then reload and resave them when the new
> server is ready. If you have a lot of packages, you can write a script
to
> do that automagically using SQL-DMO and the Package2 object.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
> I support the Professional Association for SQL Server
> www.sqlpass.org
>
> "Doug Stiers" <stiers@email.com> wrote in message
> news:ehNaTDFDEHA.2308@tk2msftngp13.phx.gbl...
> > We're building a new W2K server with the same name as the current one.
We
> > are taking down the old server, moving all the datafiles to the new
> server,
> > installing SQL Server, Analysis Services and sp3. The last time we did
> this
> > we lost our DTS packages. Can I export them somehow and then import
them?
> >
> > Are they not stored in the system tables?
> >
> > Thanks,
> > Doug
> >
> >
>
>

Relevant Pages

  • Re: Blank DTS Packages - recovers with reboot
    ... Is SQL Server on SP1? ... Rebooting the system brings the packages back. ... This is the senior developer's notes "The issue was that all DTS ...
    (microsoft.public.sqlserver.dts)
  • Re: setting DTS Global Variables
    ... I would like to execute the DTS from the command line, ... I do not want to change the database object names ... >> destination of the file to a different server through code. ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL server 2005 & DTS from SQL 2000
    ... As the DTS packages that i need to transfer into the server will also need ... We installed the Legacy Components with our SQL Server 2005 installs. ...
    (microsoft.public.sqlserver.dts)
  • Re: DST to copy from one database to another, but using a JOIN across them.
    ... Server 1 to Database B on Server 2. ... I would like this to be a DTS task (so that Many tables can be updated ... INSERT INTO tblCompany(CompanyID, CompanyName, PrimaryPerson) ...
    (microsoft.public.sqlserver.dts)
  • DTS Fails on Upsized Database
    ... DTS consistently fails on my SQL Server 2K database upsized from Access. ... Whether I upsize to an existing SQL database or create a new one, ...
    (microsoft.public.sqlserver.dts)