Hi We have SSIS package that has 2 tasks. First it applies script that creates SP's Functions and second applies the grant execute permissions on object. So the second task is failing with following error. It looks like temporary object. When SSIS tries to grant exec on this temp object it is failing because it does not exists. I looked in database and found couple of these temp objects in SP's before I figure it out they disappeared. Any idea what are these temp objects and what process it creates? Thanks.
[Execute SQL Task] Error: Executing the query "GRANT EXECUTE ON dbo.HP00011384 TO db_executor;" failed with the following error: "Cannot find the object 'HP00011384', because it does not exist or you do not have permission.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.