I have added a package from SQL Server to another package as an "Execute Package Task" it fails with this error: Error: Error 0xC0014062 while preparing to load the package. The LoadFromSQLServer method has encountered OLE DB error code 0x80040E14 (Only the owner of DTS Package 'nVision_AgentPump' or a member of the sysadmin role may create new versions of it.). The SQL statement that was issued has failed. . I tried setting the Protection Level to "don't save sensitive", and running the package in process and out. Any idea where to look? Thanks, Kayda

Are you trying to execute a DTS 2000 package? Use Execute DTS2000 Package Task, instead of Execute Package Task.

Sorry, forgot to mention that this is a SSIS package within an SSIS package. Let me know if you need any more info.. Kayda

Kayda, I am getting the same error. Did you find the solution by any chance? Please let me know. Thanks, Amit

A2meet, Could you let me know the protection level you are using on your parent and child (the package which you are calling from say, Execute Package Task) packages? check if the child has 'donot save sensitive' in that it might be the cause of the problem for you. Regards, Avik M.

Avik, I found the problem. It was a permission issue. User didnt have an access to run the package. thanks, AmitAmit Patel

I am having the same problem amit, How to set this permission in SSIS package. where is that option of giving permission. Kindly explain in detail......... Thanks in advance