Re: DTS packages on new SQL Server

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

Date: Wed, 17 Mar 2004 15:36:28 -0500

I found out how to do this by right clicking on the DTS folder in EM

I should have posted my question in: microsoft.public.sqlserver.tools

"Doug Stiers" <stiers@email.com> wrote in message
news:%231U091FDEHA.3064@tk2msftngp13.phx.gbl...
> 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: SQL 2000 - Connection Error with DTS Packages
    ... After I changed all SQL Server 'Database Connection' steps in each of my DTS ... Package" option when you right click a DTS package name in ME. ...
    (microsoft.public.sqlserver.dts)
  • Re: file conversion from SQL Server to Access
    ... You want to take data and table structure from SQL Server to Access? ... You can also have DTS create the destination tables for you. ... Is there a Northwind database ... >> www.konesans.com - Consultancy from the people who know ...
    (microsoft.public.sqlserver.dts)
  • Re: Editing DTS Packages on a 64-bit SQL Server 2005 installation
    ... The tips for running 32-SSIS packages can be extended to running 32-bit DTS ... store your DTS packages in a 64-bit SQL Server database. ... have tried installing the Web download it says to install but then I get ...
    (microsoft.public.sqlserver.setup)
  • Re: Audit of sql server
    ... The DTS database transfer makes sense now. ... >> SQL Server will not check on this for you. ... >> Compiles each query but does not execute it. ...
    (microsoft.public.sqlserver.programming)
  • Re: cannot open database requested in login
    ... Is the connection object using Windows Authentication? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > I have a DTS replication which truncates the destination> of one database and copies all the rows from the source> table of another database of same serverin> first step. ...
    (microsoft.public.sqlserver.dts)
Loading