Project for DTSx can't be opened in Visual Studio 2017

  • Hello,

    I copied entire folder of the project/soultion for DSTx (SSIS) on another Windows 2019 server/SQL 2016.

    But the project is not working there.

    Unsupported

    This version of Visual Studio is unable to open the following projects. The project types may not be installed or this version of Visual Studio may not support them.

    For more information on enabling these project types or otherwise migrating your assets, please see the details in the "Migration Report" displayed after clicking OK.

    - Data_Output, "D:\....\Data_Output.dtproj"

    I repaired the VS 2017 and rebooted the server too. Still no joy.

    VS 2017 has the SQL server data tools ticked in the Data Storage and processing tab.  see the attached screen shot.

    So, what's missing now?

    It's the same version which is working fine on production server.

    Any thoughts?

    Many thanks

    Vinay

     

     

     

    Attachments:
    You must be logged in to view attached files.
  • You also need to install SSDT for VS 2017 (standalone installer).

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Thank you Phil That works fine now.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply