SSIS job is failing
This document (7010469) is provided subject to the disclaimer at the end of this document.
"Executed as user: Domain_name\User_name. ...00.5292.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:59:31 AM Error: 2012-07-17 08:59:33.57 Code: 0x00000004 Source: Error Handling Description: The Script returned a failure result. End Error Error: 2012-07-17 08:59:33.57 Code: 0xC002F210 Source: Log Error Execute SQL Task Description: Executing the query "insert into SMCubeProcess_Log values ('Table transfer failed in cube processing: Execution failed with the following error: "Enumerate collations failed for Server 'GEDSSQL20D,8900'. ". ', 'SMCubeDepot', getdate())" failed with the following error: "Incorrect syntax near 'SQL_Server_name'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Error: 2012-07-17 08:59:33.58 Code: 0xC002F325 Source: Transfer Tables From... The package execution fa... The step failed."
GRANT EXECUTE ON OBJECT::HumanResources.uspUpdateEmployeeHireInfo
Msg 229, Level 14, State 5, Procedure sp_tablecollations, Line 1
The EXECUTE permission was denied on the object 'sp_tablecollations', database 'mssqlsystemresource', schema 'sys'.
The system stored procedure, sp_tablecollations, is undocumented by Microsoft per the following SQL Books Online article: System Stored Procedures
In some cases this system object is locked down through “hardening” of the SQL server because it is an undocumented SP.
This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.
- Document ID:7010469
- Creation Date:17-JUL-12
- Modified Date:17-JUL-12
- NetIQSecurity Manager
Did this document solve your problem? Provide Feedback