I am trying to explore an existing SSIS package that comes loaded under 'Stored Packages' with SSIS. To do this I am attaching this package in the visual studio. However, I am running into the below error on "add existing package".
I tried upgrading the packages from SSMS by clicking 'Upgrade Packages'
After attaching the existing package, I expected the result to be "Succeeded in upgrading the package"
However, I am getting the below error
TITLE: Microsoft Visual Studio
Error at Foreach Loop - Monitor Trace []: Error loading value
<DTS:ForEachEnumerator xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:CreationName="Microsoft.ForEachEventEnumerator" DTS:DTSID="{710AEAF2-45BD-4AB2-9EAF-FB6268AD10A2}" DTS:ObjectName="{710AEAF2-45BD-4AB2-9EAF-FB6268AD10A2}">
Error at SqlTraceCollect []: Cannot create a task from XML for task "TRC - Generate Trace Start Script", type "Microsoft.TraceStartScriptTask" due to error 0x80070057 "The parameter is incorrect.".
Error at TRC - Generate Trace Start Script []: Failed to load task "TRC - Generate Trace Start Script", type "". The contact information for this task is "Trace Start Script Task;Microsoft Corporation; Microsoft SQL Server 2014; © 2014 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1".
Error at SqlTraceCollect []: Element "{AC652D98-8CD6-4256-BEB0-7B937A9F6EFC}" does not exist in collection "Executables".
Error at SqlTraceCollect []: Error loading value "DTS:To="{AC652D98-8CD6-4256-BEB0-7B937A9F6EFC}"" from node "DTS:To".
Error at SqlTraceCollect []: Error loading value "
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
User contributions licensed under CC BY-SA 3.0