Package does not run with "Execute Package Task"

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Package does not run with "Execute Package Task"

Author

Topic

podgehb
Starting Member

18 Posts

Posted - 2007-06-27 : 12:47:00

I have built an SSIS package (ParentPackage) that calls another package (ChildPackage). I have loaded both packages to our production SQL Server (2005 with SP2), so they are both in the MSDB database. When I run the ParentPackage from my developer PC, it runs ok: the ParentPackage calls the ChildPackage. But when I log onto the production server and run it from there, it fails.

This is the error message I get:
Error. Error: 0xc0014062 while preparing to load the package. The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login failed for user ''. The user is not associated with a trusted SQL Server connection. ). The SQL Statement that was issued has failed.

Some points:
(1) To make debugging easier, I removed all tasks from the packages except the Execute Package Task in the ParentPackage.
(2) The ParentPackage is connecting to the ChildPackage using a connection object with this connection string:
Provider=SQLNCLI.1;Data Source=MyProductionServer;Integrated Security=SSPI;Initial Catalog=MyDatabase
(3) The production server has SQL Server 2005 Standard Edition and my machine has SQL Server 2005 Developer Edition -- could this problem be due to a feature that you need Enterprise Edition for?
(4) I have tried it on another developer machine (with SQL Server 2005 Developer Edition) and it worked
(5) If the package does run another package, it

Any idea why it does not run on our production server?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-27 : 22:54:03

Does your windows account have same kind of permission on both machines?