Post reply

Error while deploying the cube in SSIS

  • May 7, 2011 at 7:00 am

    #389469

    Hi Every Body

    As i am new in SSAS. I want to deploy the cube but it display following error.

    Parser: the syntax for the ImpersonationInfo object is incorrect. If the ImpersonateAccount value is used for ImpersonationInfo, then the Account property cannot be empty.

    so please help me in this regards.

  • May 10, 2011 at 3:42 am

    #1322174

    deploy it in SSIS?

    er..is the SSAS database and cube on the server?

    can you open the cube in Visual Studio?

  • May 10, 2011 at 7:42 am

    #1322301

    The SSAS Service uses a Windows account to connect to the underlying data source. Double click the data source object (*.ds) an open the impersonation tab. Probably you have chosen "Use the credentials of the current user", but SSAS does not support impersonation of the current user for object processing.

    Instead use another account with the appropriate permissions on the data source.

    Read more in the BOL under Defining a Data Source Using the Data Source Wizard, section Defining Impersonation Information.

    ...

  • May 13, 2011 at 2:40 am

    #1324126

    ...

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply