SSIS Visual Studio Community 2017 Error opening file
Using:
- SQL Server Management Studio 18
- Visual Studio Community 2017
When attempting to open a file in Visual Studio but fails at creating project (action) with the following error message:
===================================
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()