May 23, 2006 at 11:56 am
I am getting following error message in the DTS log file
Step 'DTSStep_DTSOlapProcess.Task_1' failed
Step Error Source: DSO
Step Error Description:Cannot connect to the repository.
Analysis server: toronto
Error:
Unspecified error
Step Error code: 80040033
Step Error Help File:
Step Error Help Context ID:1000440
Step Execution Started: 5/23/2006 11:52:57 AM
Step Execution Completed: 5/23/2006 11:52:57 AM
Total Step Execution Time: 0.125 seconds
Progress count in Step: 0
why is DTS not able to connect to repository? could it be privelege issue?
May 23, 2006 at 12:16 pm
Yes, it could be a privelege/rights issue. If you are able to execute the package from the DTS designer, but cannot as a job, check the job owner. Make sure the job owner can access the repository.
May 23, 2006 at 12:37 pm
is the only way to give access to analysis service is to make the user part of olap admin group?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply