SSIS Visual Studio Community 2017 Error opening file

Rosie Lopez 0 Reputation points
2024-05-17T21:00:44.0233333+00:00

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()

Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
982 questions
{count} votes