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 |