|
Error While running SSIS package from JOB scheduler to update Cube
30/08/2007 6:28:34 PM
(Total replies: 1)
|
| HI All,
I don’t know if this is good place to ask question regarding SSIS package.
Scenario
-------------
I am trying to write DTS package to schedule automatic processing of Cube in analysis service Database.
DTS package runs fine from the Visual studio environment but when I am trying to run package from Job scheduler I receive below specified error. If some have find resolution to this problem and can share with me that will be great.
Error iam ... |
|
|
|
Re: Error While running SSIS package from JOB scheduler to update Cube
31/08/2007 9:22:07 AM
(Total replies: 1)
|
| Hi Phil,
Following steps i have taken to Create Credentials and Create Proxy
1.I have Created Login to have access to msdb and assigned SQLAgentOperatorRole,SQLAgentReaderRole,SQLAgentUserRole.
2.I have create Credentials Using previuosly created login.
3. Created Proxy user in SQL ServerAgent and Assign to SSIS.
It will great help if you can help me to resolve this issue.
Thanks
Ritesh
|
|