SSIS Error - At a lost?? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

SSIS Error - At a lost??

Author

Topic

ostinoh
Yak Posting Veteran

66 Posts

Posted - 2012-02-16 : 14:26:06

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.

Date 2/16/2012 2:00:00 PM
Log Job History (BackLogLabor Pull From Production)

Step ID 1
Server SXP00SQL07E\FINP02
Job Name BackLogLabor Pull From Production
Step Name Data Pull
Duration 00:08:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

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.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-02-17 : 07:29:44

If the object exists, then the account the package is executing under doesn't have permission.

If the package is creating the object, make sure the create object and grant permission are in seperate batches.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-17 : 14:19:04

if its account having no acces to objects, grant access using GRANT command

Also check if connection managers are pointed to correct database.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources