Home Forums SQL Server 2017 SQL Server 2017 - Development Error Processing Cube from SSIS package run as a SQL Job RE: Error Processing Cube from SSIS package run as a SQL Job

  • April 10, 2018 at 8:29 am

    #1986141

    Brian Shaw - Tuesday, April 10, 2018 7:53 AM

    Thanks for the reply Phil.

    All data sources are pointing to the correct DB instance.  Since it processes fine in VS I know those connections are good.
    The data source impersonation was set to "Default", I changed it to "ImpersonateServiceAccount", but still received the error. The SSAS service account does have access to the datasource.

    -Brian

    The annoying thing is that I had this error not so long ago ... and, you know how it is, I can't remember how I solved it.
    I'll post back if my memory manages to dredge up anything useful.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.