Viewing 6 posts - 1 through 6 (of 6 total)
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...
February 18, 2017 at 12:19 pm
Could not reproduce this issue. Try recreating the task.
February 18, 2017 at 7:11 am
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...
February 18, 2017 at 5:28 am
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',...
February 10, 2017 at 12:31 pm
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...
February 10, 2017 at 11:22 am
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...
February 10, 2017 at 10:05 am
Viewing 6 posts - 1 through 6 (of 6 total)