Not opening VSTS project on VS 2015

Question

_{Thursday, October 25, 2018 6:54 PM}

I have installed Visual Studio 2015, SSDT for VS 2015, Kingsway Soft for SSIS, and connected to VSTS, but the project in VSTS is not opening in VS 2015.  The error message is get is this:

"
There is an error in XML document (36786, 10). (Microsoft Visual Studio)

Instance validation error: 'SQLServer2017' is not a valid value for DTSTargetServerVersion. (Microsoft.GeneratedCode)

Program Location:

   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderProjectSerialization.Read9_DTSTargetServerVersion(String s)
   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderProjectSerialization.Read10_Item(Boolean isNullable, Boolean checkType)
   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderProjectSerialization.Read11_Item(Boolean isNullable, Boolean checkType)
   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderProjectSerialization.Read12_ProjectSerialization(Boolean isNullable, Boolean checkType)
   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderProjectSerialization.Read13_Project()

I would be grateful if someone could advise me on how to resolve this.  Please note, the project was not created by me, but I have to open it.  It is SSIS Package created with VS 2015.

Thank you.

Longinus

LOE

All replies (5)

_{Monday, October 29, 2018 10:50 PM ✅Answered | 1 vote}

I eventually resolved it.  I saw on Visual Studio notification pane a notice to update the SSDT, I did the update and the issue was resolved.

Thank you Team.

LOE

_{Friday, October 26, 2018 7:31 AM}

Hi friend,

Welcome to the MSDN forum,

Based on your error message, it seems to be related with a specify deployment target version.

Please check the VS version and SQL Server version of your project.  Then open your project and right-click it in solution explorer, click “property” to check the target version.

Best Regards

May

MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [email protected]

_{Monday, October 29, 2018 1:14 AM}

Hi friend,

Is there any update for your issue?

Did you have a try to check the target version?

May

MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [email protected]

_{Monday, October 29, 2018 10:47 PM}

May,

Thank you for the response.  You are correct, the target server version was the issue.  Since I was not the person who created the project and was unable to open it, it was not possible to reset the server version.

Thank you.

Longinus

LOE

_{Thursday, January 24, 2019 10:29 AM}

Hello there.

Open ur xml (it is something.dtproj etc.)

Find the row  that is for u (36786)

U will see the target version is 2017.

write there the correct version.

Then save and reload the project.