February 16, 2012 at 12:25 pm
Hello -
When my SSIS package runs from a SQL Server Agent job I get the following error message. Can someone help me with this one? I see the table and the users are active.
Date2/16/2012 2:00:00 PM
LogJob History (BackLogLabor Pull From Production)
Step ID1
ServerSXP00SQL07E\FINP02
Job NameBackLogLabor Pull From Production
Step NameData Pull
Duration00:08:00
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: ROSETTA\finp01sql.agent. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 2:00:00 PM Error: 2012-02-16 14:08:00.24 Code: 0xC002F210 Source: Grant Rights Back Execute SQL Task Description: Executing the query "GRANT SELECT ON BacklogLabor TO [Rosetta\Sage Mana..." failed with the following error: "Cannot find the object 'BacklogLabor', 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. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:00:00 PM Finished: 2:08:00 PM Elapsed: 479.515 seconds. The package execution failed. The step failed.
February 16, 2012 at 11:46 pm
Either the object doesn't exist, or the SQL Server Agent account doesn't have GRANT permission.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply