06243315   
   From: esquel@sommarskog.se   
      
   Neil Cudd (neil.cudd@blueyonder.co.uk) writes:   
   > I have 2 servers - one production, one test.   
   > Both are Win 2003 R2 Std x64 SP2, SQL Server 2005 std 64bit SP3   
   > The production server has multiple instances (5)   
   > The test server has one instance.   
   > They both have SQL 2005 Backward compatability and SQL 2000 DTS   
   > components installed.   
   > On both servers I have 'migrated' a number of DTS packages by opening   
   > the package in SQL 2000 (old server) and saving to the new 2005 64bit   
   > servers.   
   >   
   > On the test server I can run the DTS packages from the command line   
   > using dtsrun.   
   > On the production server, if I try to run packages on the named   
   > instance I get :   
   >   
   > cmd> DTSRUN /S \ /N "" /E   
      
   Do you run DTSRUN on the same machine as the instance, or do you   
   run DTSRUN from a different machine? Is the production server a   
   cluster?   
      
   If you run DTSRUN on the same machine, and it is not a cluster, check   
   the spelling of the server and instance names.   
      
   If you run DTSRUN from a different machine, make sure that the Browser   
   server is running on the production machine. Can you cannot to the   
   instance through SSMS and other tools remotely?   
      
   If you are on a cluster, you should specify the cluster name, not the   
   local machine name, I believe.   
      
      
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)