Added additional task in sub-plan. Following error occurred:
Executed as user: ASSET-FM\sqlagentadprod. ...4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:03:45 PM Error: 2011-11-10 13:03:46.28 Code: 0xC0014100 Source: {BDAC57A7-C5B7-432F-AB4D-E51DDF122D50} Description: The object cannot be added because another object with the same name already exists in the collection. Use a different name to resolve this error. End Error Error: 2011-11-10 13:03:46.29 Code: 0xC0010021 Source: {BDAC57A7-C5B7-432F-AB4D-E51DDF122D50} Description: Element "{3F42EE53-10C7-44BE-806C-BDCB18EF64EF}" does not exist in collection "Executables". End Error Error: 2011-11-10 13:03:46.29 Code: 0xC0010018 Source: {BDAC57A7-C5B7-432F-AB4D-E51DDF122D50} Description: Error loading value "<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" IDREF="{3F42EE53-10C7-44BE-806C-BDCB18EF64EF}" DTS:IsFrom="-1"/>" from node... The return value was unknown. The process exit code was -107374... The step failed.
User added another DTS task to the plan with the same name.
Quick resolution:
Disabled current plan and recreated new one.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center