dbTalk Databases Forums  

SSIS nested package error

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS nested package error in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Matt Frend
 
Posts: n/a

Default SSIS nested package error - 03-31-2008 , 08:52 PM






Hi,
We get an error running a SSIS package which calls another package. Both
packages execute Ok independently. Error: "The LoadFromSQLServer method has
encountered OLE DB error code 0x80040E09 (The EXECUTE permission was denied
on the object 'sp_dts_getpackage', database 'msdb', schema 'dbo'". The user
running the package has db_dtsOperator role in the MSDB. This is occurring
on more than 1 test server, but the same package is working Ok on our
production box.

url:http://www.ureader.com/gp/1146-1.aspx

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.