I recently got a new computer and trying to open a project in Visual Studio Community 2017 but fails with the error below:
My old computer was using Windows 11, SSMS 18, with Visual Studio Community 2017. In the new computer I have installed the same programs. To develop and manage ETL solutions we used the following installations: Salesforce – Integration Toolkit, SSDT, SSIS Power Pack Setup, and VS Community 2017, which I have downloaded in the new computer.
I
Full error from SSIS:
===================================
Value does not fall within the expected range. (Microsoft.SqlServer.ManagedDTS)
——————————
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Interop.ProjectInterop.ReferencePackage(Package package, String packageLocation)
at Microsoft.SqlServer.Dts.Runtime.PackageItem.Load(IDTSEvents events)
at Microsoft.SqlServer.Dts.Runtime.PackageItem.get_Package()
at Microsoft.DataTransformationServices.ImportProjectWizard.ImportProjectWizardTask.<>c__DisplayClass19_0.<ImportProject>b__1()
at Microsoft.DataTransformationServices.ImportProjectWizard.ImportProjectWizardTask.PerformStep(ActionName currentAction, StepCallback callback)
at Microsoft.DataTransformationServices.ImportProjectWizard.ImportProjectWizardTask.ImportProject()
at Microsoft.DataTransformationServices.ImportProjectWizard.ImportProjectPage.OnSetActive()
I have tried uninstalling and installing all programs, repair installed packages, restart my computer and reach out to Microsoft Technical Support team through their chat but they were not able to help me. I also have a posted to MS community page and waiting to hear back from them.