Is there a fix for the error the below error that I get while trying to 'Attach an existing SSIS package' in Integration services in Visual studio

0

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)

ssis
ssis-2017
asked on Stack Overflow Apr 8, 2019 by Komal Bachhuka • edited Apr 9, 2019 by Dijkgraaf

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0