CODEWITHSUNDEEP
sql-servervisual-studio-2010ssis
chris
chris

Reputation: 37460

What do I need to work with a Visual Studio .dtproj file?

I have a .sln file created in Visual Studio 2010:

Microsoft Visual Studio Solution File, Format Version 11.00
# Visual Studio 2010

This has a single Project which is a .dtproj file. The header of this file looks like:

<?xml version="1.0" encoding="utf-8"?>
<Project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <DeploymentModel>Project</DeploymentModel>
  <ProductVersion>11.0.2100.60</ProductVersion>
  <SchemaVersion>9.0.1.0</SchemaVersion>

I have VS 2010 Professional installed, but when I try to open this solution I get an error that the project type is not supported.

This machine also has VS2008, VS2012, and SQL Server 2008R2 with the BI Dev Studio.

What am I missing? How can I get support for this .dtproj project type?

Upvotes: 12

Views: 15645

Answers (2)

Sajid Ali
Sajid Ali

Reputation: 779

You need to install the project extension for this purpose. Here is the download link from marketplace.

https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

For VS 2022, you should go to https://marketplace.visualstudio.com/items?itemName=SSIS.MicrosoftDataToolsIntegrationServices

After that you need to restart the visual studio and you should be open up the project without any issue.

Upvotes: 8

dotNET
dotNET

Reputation: 35400

Looks like MS has a solution for you (from Microsoft Support):

To resolve the issue in which you cannot open the project in SQL Server BIDS after you upgrade the project, follow these steps:

  • Create a new project that has the same name as the original BI project in a different directory by using SQL Server BIDS.
  • Add all relevant project items from the upgraded BI project folder. For example, for an Analysis Services project, add the .ds and .dsv files. For a Reporting Services project, add the .rds and .rdl files.
  • Save and then open the new BI project.

You can read more about it here.

Upvotes: 0

Related Questions