Weird situation, here are the details:

1. Tried to add a linked server (SQL serv.7 -> SQL Serv. 7). Server was
added but when I click on Tables I get "Specified SQL Sever not found"

2. Made up DTS packages (as second option) which work perfectly when executed,
HOWEVER, when I schedule them (either thru DTS wizard OR a job) they fail
with the same "Error 6: Specified SQL Sever not found"

What the heck is going on? I shouldn't have to write a VB exe in order to
move data!!??!! Please Help!


Here is the full error text from the job history:

DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Delete from
Table [PCDP].[dbo].[PwrEquipment] Step DTSRun OnError: Delete from Table
[PCDP].[dbo].[PwrEquipment] Step, Error = -2147008507 (80074005) Error
string: Unspecified error Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts.hlp Help context: 1100
Error Detail Records: Error: -2147008507 (80074005); Provider
Error: 0 (0) Error string: Unspecified error Error source:
Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp
Help context: 1100 Error: -2147467259 (80004005); Provider
Error: 6 (6) Error string: [DBNMPNTW]Specified SQL server not found.
Error source: Microsoft OLE DB Provider for SQL Server Help file:
Help context: 0 DTSRun OnFinish: Delete from Table [PCDP].[dbo].[PwrEquipment]
Step DTSRun: Package execution complete. Process Exit Code 1. The step
failed.