SSIS 2012 Package Editing using Visual Studio 2012

When attempting to open an SSIS package created by Sql Server Data Tools from the Sql Server 2012 install, using Visual Studio 2012, the text (incompatible) appears beside the project name and the package icon appears with a blue circle on it.

Image

If you try to open the package, a message appears saying “The application is not installed.”. The package would open without any problem using Sql Server Data Tools under the Microsoft SQL Server 2012 folder on the Start menu, which uses the Visual Studio 2010 shell.

To resolve this you need to install a Microsoft SQL Server Data Tools update.

http://www.microsoft.com/en-us/download/details.aspx?id=36843

Download and run SSDTBI_VS2012_x86_ENU.exe on your system. During the installation expect an SQL Server 2012 Setup panel to appear. Click Next to go start the setup. By default it may be set to install a new instance of SQL Server, keep this setting because you are not creating a new database engine, just the data tools. Select “SQL Server Data Tools – Business Intelligence for Visual Studio 2012” under Shared Features, on the Feature Selection panel. Open Visual Studio 2012 and create a new project. You should see the Business Intelligence projects available on the left hand side.

Advertisements
Tagged with: ,
Posted in Development
One comment on “SSIS 2012 Package Editing using Visual Studio 2012
  1. Nate says:

    “By default it may be set to install a new instance of SQL Server, keep this setting because you are not creating a new database engine, just the data tools.”

    Thanks!! This helped out a lot!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: