Re: How to migrate more than 200 DTS to other server

Tech-Archive recommends: Fix windows errors by optimizing your registry

For 2000 to 2005, here are some more links-

Upgrading DTS
(http://wiki.sqlis.com/default.aspx/SQLISWiki/UpgradingDTS.html)


For 2000 to 2000 -

DTSBackup 2000
(http://www.sqldts.com/default.aspx?242)

Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)



--
Darren
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

"Arnie Rowland" <arnie@xxxxxxxx> wrote in message
news:%23Pm2IpW8GHA.2384@xxxxxxxxxxxxxxxxxxxxxxx
This article may help:

DTS -Transfer DTS Packages to SQL Server 2005 SSIS
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1216481,00.html


--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Mike Torry" <MikeTorry@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A6AEFE37-92E2-4EC1-BCDC-BE2773180ECD@xxxxxxxxxxxxxxxx
I have more that 200 DTS packages saved in "Local Packages" under SQL
Enterprise Manager. I know I can save them one by one to migrate to other
serevr.
Are there any easy way to migrate all 200 DTS ?

Thanks for help,






.

Relevant Pages

  • Re: SQL Server 2000 DTS Designer Components
    ... I seem to remember it taking some effort to get the DTS components working in SQL 2005 x64 also. ... The error was "SQL Server 2000 DTS Designer components are required to edit DTS packages. ... Install the special web download 'SQL Server 2000 DTS Designer Components' to use this feature". ...
    (microsoft.public.sqlserver.clients)
  • Re: DTS and version control software
    ... my original plan was to store the VB code in source safe and use it to ... > task and then look at each transformation object and get the ... > www.SQLDTS.com - The site for all your DTS needs. ... >>> I'm considering using DTS packages for certain database tasks. ...
    (microsoft.public.sqlserver.dts)
  • Re: Migrating DTS to Integration Services
    ... DTS -Transfer DTS Packages to SQL Server 2005 SSIS ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.dts)
  • Opening DTS package from .dts file and Error - Type Mismatch
    ... I need to save DTS packages on other machine and other MS SQL server. ... I tryied to re-install MSSQL server but the error is again. ...
    (microsoft.public.sqlserver.dts)
  • RE: Opening DTS package from .dts file and Error - Type Mismatch
    ... > I need to save DTS packages on other machine and other MS SQL server. ... > I tryied to re-install MSSQL server but the error is again. ...
    (microsoft.public.sqlserver.dts)