Visual Studio 2010 installation error

kkran 831 Reputation points
2020-10-28T13:22:09.52+00:00

Hello Everyone - I installed Visual Studio 2010, visual studio SP1 , SQL server data tools (SSDT) 2012, and SQL server 2012 instance. But whenever i open SSIS packages (dtsx file) through Visual studio 2010 i get the below error. How do i resolve this ? Am i missing any installation or do i need to configure anything ? please help.
35660-image001.jpg

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,606 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,453 questions
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.
964 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,816 Reputation points
    2020-10-28T14:07:45.957+00:00

    I installed Visual Studio 2010, visual studio SP1 , SQL server data tools (SSDT) 2012

    Because you installed SSDT 2012 and that is for VS 2012.
    Better install & use the latest version of SSDT from https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15

  2. Yitzhak Khabinsky 24,946 Reputation points
    2020-10-28T15:12:55.017+00:00

    Hi @kkran ,

    What is important is your targeted SSIS run-time environment. It seems that you have SQL Server 2012 instance with the Integration Services (SSIS) installed.

    You don't need to be stuck with the obsolete version of VS2010.
    That's why on your development machine you can use VS2019 with the SQL Server Integration Services Projects. It is compatible with all SSIS versions, starting from SSIS 2012 onwards.

    Such setup will support all what you need. Please see below a screen shot of it in VS2019.

    35648-ssis-targetserverversion-2.png

  3. Monalv-MSFT 5,891 Reputation points
    2020-10-29T02:36:02.213+00:00

    Hi @kkran ,

    May I know if you open ssis packages in SQL Server Data Tools (SSDT)?

    Please refer to the following steps:

    Add an existing project to a solution

    1. In SQL Server Data Tools (SSDT), open the solution to which you want to add an existing Integration Services project, and do one of the following:
    a. Right-click the solution, point to Add, and then click Existing Project.
    b. On the File menu, click Add, and then click Existing Project.
    2. In the Add Existing Project dialog box, browse to locate the project you want to add, and then click Open.
    3. The project is added to the solution folder in Solution Explorer.

    Add an item to a project

    1. In SQL Server Data Tools (SSDT), open the solution that contains the Integration Services project to which you want to add an item.
    2. In Solution Explorer, right-click the project, point to Add, and do one of the following:
    a. Click New Item, and then select a template from the Templates pane in the Add New Item dialog box.
    b. Click Existing Item, browse in the Add Existing Item dialog box to locate the item you want to add to the project, and then click Add.
    3. The new item appears in the appropriate folder in Solution Explorer.

    Best Regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues in October--Users always get connection timeout problem when using multi subnet AG via listener. Especially after failover to another subnet .