Cube not processing from SSIS package run from SQL Agent

• caffaguido

  Valued Member

  Points: 72

  More actions

  November 21, 2018 at 8:51 am

  #368961

  I have a cube create in SSIS.

  

  If i process the cube from de Analysis server instance, or from my SSIS pacakge (in visual studio) it work's correctly. If i run the job in SQL Agent, the first task (green) run correctly. The problem start when the job need to process the dimensions and the cube (red). There is no error, and the job "Finish" correctly. i see this post in the forum, but this don't solve the problem.

  Any idea? thanks!

• Mike01

  SSChampion

  Points: 11412

  More actions

  November 21, 2018 at 10:16 am

  #2014264

  Did you look in Integration Services Catalog?

  For better, quicker answers, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Michael L John

  One Orange Chip

  Points: 27065

  More actions

  November 21, 2018 at 10:22 am

  #2014266

  Can you get and provide the exact error? As Mike01 suggested, you can view this in the SSISDB.

  I suspect it's a permissions issue.  The service account running the package does not have rights to process the cube.

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/