dbTalk Databases Forums  

Duplicate name error during scheduled DTS-processing

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Duplicate name error during scheduled DTS-processing in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michael Barrett Jensen
 
Posts: n/a

Default Duplicate name error during scheduled DTS-processing - 10-19-2004 , 07:54 AM






I have a DTS package setup to process my Analysis Services cubes and a job
scheduled to kick off the DTS package. I can run the package fine
interactively, but when run from a SQL Agent job the following error is
returned in my log file:

The execution of the following DTS Package failed:

Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description:A duplicate name exists on the network.

Error code: 800A0034
\Error Help File:sqldts80.hlp
Error Help Context ID:700


Package Name: Process AssignedSales Cubes
Package Description: (null)
Package ID: {2C4ADBDC-2425-4BEB-9E46-33A2BF5232A0}
Package Version: {01DEB18E-AD37-4928-827D-62012EE45D3F}
Package Execution Lineage: {A717F720-781B-4ADE-80AA-6492C977692F}
Executed On: STL-SQLDATA
Executed By: sqlexec
Execution Started: 2/10/2004 8:47:49 AM
Execution Completed: 2/10/2004 8:47:50 AM
Total Execution Time: 0.953 seconds

Package Steps execution information:


Step 'DTSStep_DTSOlapProcess.Task_3' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:A duplicate name exists on the network.
(DTSOlapProcess (80004005): Bad file name or number)
Step Error code: 800A0034
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:700

Step 'DTSStep_DTSOlapProcess.Task_1' was not executed

Server details:
Win2003 Cluster (3 servers)
SQL 2K EE, SP3a
SQL Server and Agent run under same account (standard domain account, not a
local administrator)
Analysis Services, SP3a

Any ideas on this? :-)

/Michael



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.