How can I downgrade an SSIS project for use with VS 2017 standalone?



  • I inherited a project that was being built in VS 2019. After I finished building it and asked the requestor for clarification on how to handle a few scenarios I get a warning that the license for VS 2019 is about to expire. Turns out the project was running on the 30 trial license. The server is on a network that is isolated in such a way I can't use an MSDN account to sign in. We were able to get VS 2017 Standalone shell installed with data tools using the off line method. Now the problem is I have a 2019 project and dts package with 2017 tools. Is there a way to downgrade the project to 2017?



  • Unfortunately, you cannot automatically regress packages to previous VS project versions. Essentially, previous versions simply do not know what changes may have occurred to a component or pipeline, so if a higher-than known version number is detected, you will probably have to rebuild the component or affected task. While often this shouldn't be more than a mild-to-moderate annoyance, if you are using a lot of script tasks you'll likely have to open the .dtsx file in your text editor of choice to retrieve the custom definitions.

    As https://dba.stackexchange.com/questions/308389/how-can-i-downgrade-an-ssis-project-for-use-with-vs-2017-standalone#comment602417_308389 comments, you could also pull a copy of the package off the server to be opened with a community version of the tool if a rebuild effort is determined to be necessary. However, until licensing gets sorted out, you are effectively being forced to treat VS 2017 as the new target version for the time being. You can always upgrade to a newer version from there when new keys are provided.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2