SQL Server SSIS issue.

• Saggy

  SSCrazy

  Points: 2003

  More actions

  January 11, 2012 at 6:49 am

  #248834

  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

• Evil Kraig F

  SSC Guru

  Points: 100851

  More actions

  January 11, 2012 at 11:43 am

  #1432022

  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[/url] | Forum Netiquette
  For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
  Twitter: @AnyWayDBA

• Sivaganesh Tamilvendhan

  Hall of Fame

  Points: 3498

  More actions

  July 16, 2012 at 6:00 am

  #1513018

  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