DTS Edited In SQL Server 2005

[Skittle]

I needs to move a pile of DTS packages from an SQL Server 2000 sever to an SQL Server 2005 server.

I have imported a .DTS file into the SQL Server 2005 system and I can open it with the DTS editor in Sql Server 2005 Management Studio ( I have the legacy tools installed ).
The imported package references the local SQL Server.
On my old server that was of course the SQL Server 2000 database. On my new server it is the SQL Server 2005 database I have restored from the old server.

The problem is, the DTS package on my SQL Server 2005 server does not 'see' the server. '(Local)' does not work and I cannot browse to my 2005 computer name. I get the error:-

Miscrosoft OLE DB Providor for SQL Server. Error description : [DBNETLIB][ConnectionOpen(Connect))]SQL server does not exist or access denied.


Hmmm.
So.... I have copied over an SQL Server 2000 DTS package that works with local databases but it cannot see an SQL Server 2005 local database????

Anybody know why???





Dazed and confused

 

[RiverGuy]

Does your sql server have an instance name? for example (local)\SQL2005?

 

[MDXer]

Along with riverGuy's question the next would be if not what port is it running on?

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[Skittle]

It uses the computer name and the default port.

Dazed and confused