Re: SQL server 2005 & DTS from SQL 2000

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Russell,

thanks for replying.
i installed "SQLServer2005_DTS.msi" first and now the "Microsoft SQL Server
2005 Backward Compatibility Components".

Would you recommend that i re-install them in this order?
1. "Microsoft SQL Server 2005 Backward Compatibility Components"
2. "SQLServer2005_DTS.msi"

i can't see an option within SQL server management studio for DTS and also
no applications appear within the start menu.

ian

n.b. i've not re-started the server.

"Russell Fields" wrote:

Ian,

If you did not do so, you also need to install the "Microsoft SQL Server
2005 Backward Compatibility Components" from the same page listed in your
post. Install this on the server and the desktop.

Although I am on SQL Server 2005 for many servers, we still have many DTS
packages running the legacy (SQL 2000) DTSRUN command. So, once you get all
the pieces in place, it should all work fine.

RLF

"Ian Oldbury" <IanOldbury@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4F76D82E-3812-4093-AB27-F7CD916E05E4@xxxxxxxxxxxxxxxx
Hi,

We have a new installation : SBS 2003, SQL 2005. this machine replaces a
SQL
2000 installed machine.

The problem we've got is that we need to bring the SQL 2000 DTS packages
to
the new SQL 2005 server.

i've read that the Microsoft SQL Server 2000 DTS Designer Components
(http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en)
are required.

i've installed the SQLServer2005_DTS.msi component, nothing appears to
have
changed within SQL 2005.
Is anything else required? As we need to be able to run the old DTS
packages?





.

Relevant Pages

  • Re: What does this error mean?
    ... I would still favour a login problem. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ...
    (microsoft.public.sqlserver.dts)
  • Re: importing JUST data from Access 97 into SQL Server 2000
    ... then you can find the information you need to specify on the Access ... www.SQLDTS.com - The site for all your DTS needs. ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: Run DTS within a DTS, OLAP job fails
    ... Have you got all tasks that connect to the Sub Package(DTS OLAP task) ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > I have made a simple DTS that processes an OLAP job. ...
    (microsoft.public.sqlserver.dts)
  • Re: What files are required to use DTS on a client?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: Setting DTS Name property
    ... Sample Custom Task Project ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ...
    (microsoft.public.sqlserver.dts)