Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: How to script out SSIS catalog permissions?

    In SSISDB database, permissions can be granted by making use of stored procedure "catalog.grant_permission". SSIS catalog permission are saved in four kind of objects used in view [internal].[object_permissions]
    They are...

  • RE: Date conversion Error in SSIS package

    Could not reproduce this issue. Try recreating the task.

  • RE: How to script out SSIS catalog permissions?

    Hi,

    SSIS Catalogs are maintained via SQL database SSISDB. All the permissions of SSIS catalog folders, environments etc are maintained in table. So you would need to prepare script...

  • RE: Cube processing error

    Next error I received was:

    Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_FactInternetSales', Column: 'DueDateKey', Value: '20050713'; Table: 'dbo_FactInternetSales', Column: 'DueDateKey',...

  • RE: Cube processing error

    I created the dimdate balanced hierarchy with MonthNumberOfYear at top and then DateKey. In the cube dimension usage tab, I defined a regular relationship with granularity attribute DateKey, for dimension...

  • RE: Cube processing error

    Thanks for your response. It was good to know that column four is the one suffixed_4. I have observed the query in the processing screen. It is :

    SELECT...

Viewing 6 posts - 1 through 6 (of 6 total)