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 |