|
Error While running SSIS package from JOB scheduler to update Cube
Posted: 30 Aug 2007 06:28 PM |
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 receiving while executing package on SQL server 2005
----------------------------
9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 05:51:21 PM Error: 2007-08-30 17:51:21.34 Code: 0x00000000 Source: Analysis Services Processing Task Analysis Services Processing Task Description: A connection cannot be made. Ensure that the server is running. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 05:51:21 PM Finished: 05:51:21 PM Elapsed: 0.344 seconds. The package execution failed. The step failed.
Regards
Ritesh Agarwal
|
|
|
 |
|
|
Re: Error While running SSIS package from JOB scheduler to update Cube
Posted: 31 Aug 2007 12:25 AM |
What credentials are used to connect to the server?
|
Thanks
Phill
Colt 45 - the original point and click interface ;)
http://philcart.blogspot.com/ |
|
|
|
|
Re: Error While running SSIS package from JOB scheduler to update Cube
Posted: 31 Aug 2007 09:22 AM |
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
|
|
|
|
|
 IRytCod
|
| Joined: 04 Oct 2007 |
| Total Posts: 2 |
| |
|
Re: Error While running SSIS package from JOB scheduler to update Cube
Posted: 04 Oct 2007 08:49 AM |
| We are getting the same error, did you figure out the solution yet?. All credentials are there and appropriate services are running. One of the SQL 2005 server is working fine but other one throws the error similar to yours when trying to execute the Analysis server cube through SQL Agent. |
|
|
|
|
IRytCod
|
| Joined: 04 Oct 2007 |
| Total Posts: 2 |
| |
|
Re: Error While running SSIS package from JOB scheduler to update Cube
Posted: 10 Oct 2007 04:29 AM |
| We got it working, the account used for setting up services (SQL server, SQL server agent, etc) was local, once we changed it to domain admin account it worked. |
|
|
|
|