SQL Server SSIS issue.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQL Server SSIS issue.

SQL Server SSIS issue.

Rate Topic

Display Mode

Topic Options

Author

Message

Saggy

Posted Wednesday, January 11, 2012 6:49 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, April 04, 2013 11:40 AM
Points: 52, Visits: 157

hi guys...

SQL Server 2008 R2 Standard Edition 64 Bit

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The SELECT permission was denied on the object 'sysdtspackages', database 'msdb', schema 'dbo'. (Microsoft SQL Server, Error: 229)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

please help....thnx

Post #1233940

Evil Kraig F

Posted Wednesday, January 11, 2012 11:43 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 12:05 AM
Points: 5,688, Visits: 6,142

Is this being ran from a job? Sounds like the SQLAgent login doesn't have system db rights.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables
Twitter: @AnyWayDBA

Post #1234248

sivajii

Posted Monday, July 16, 2012 6:00 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:15 AM
Points: 209, Visits: 1,325

hi saggi

follow this step mentioned in the website i hope it help u

http://rajeshssingh.blogspot.in/2010/02/exception-occurred-while-executing.html

if it works mean just reply me

Post #1330051

« Prev Topic | Next Topic »

Permissions