DTS/linked server error #6
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
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL