SSIS solution cannot be installed on SQL Server 2014 instance

  • Hi all,

    I have a SQL Server 2012 SSIS solution developed in Visual Studio 2012.

    I wanted to run some tests to see how it will behave on SQL Server 2014 but I cannot deploy the solution to this edition.

    I used a new VM where I have installed Windows Server 2012 R2.

    Then I installed SQL Server 2014 Enterprise Edition x64.

    The solution comes with 2 databases that were deployed successfully, but the SSIS solution cannot be installed.

    The returned error is: "A .NET Framework error occurred during execution of user-defined routine or aggregate "deploy_project_internal":

    System.Data.SqlClient.SqlException: The required components for the 64-bit edition of Integration Services cannot be found. Run SQL Server Setup to install the required components."

    I have searched for relevant info on the internet but nothing seems to help.

    Do you have any ideas what can be the cause?

    Thank you in advance!

  • This is how it looks like (attachement).

  • According to this link it seems like I need to upgrade all the packages to make them work.

    http://msdn.microsoft.com/en-us/library/bb522577.aspx

    I will give a try and let you know if this is the solution.

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

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