SSIS Pakage Error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » SSIS Pakage Error

SSIS Pakage Error

Rate Topic

Display Mode

Topic Options

Author

Message

faisal.jamil

Posted Thursday, September 27, 2012 2:05 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 03, 2012 6:29 AM
Points: 4, Visits: 21

Executing SSIS package i am getting following error.

[Execute SQL Task] Error: Executing the query "exec proc_BusinessRulesValidation @UserName = ?,
@..." failed with the following error: "MDSERR120002|The user does not have permission to perform this operation.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

But when this task is executed only, it is successfully. Which means it is not a user permission issue.

Post #1365083

sumit.joshij

Posted Thursday, September 27, 2012 2:30 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 6:06 AM
Points: 47, Visits: 266

Please check your SP rights. this problem exist when the rights are not placed to you... Wink

Post #1365092

faisal.jamil

Posted Thursday, September 27, 2012 2:42 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 03, 2012 6:29 AM
Points: 4, Visits: 21

Post #1365094

faisal.jamil

Posted Monday, October 01, 2012 3:04 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 03, 2012 6:29 AM
Points: 4, Visits: 21

No dear, It is fine for one model (Product_WIP) means executed successfully but genernating error with another model (Product).

Post #1366404

Tee Time

Posted Wednesday, October 03, 2012 2:59 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 11:27 AM
Points: 321, Visits: 236

Are you running as Administrator?

Post #1368051

« Prev Topic | Next Topic »

Permissions