Change .NET Framework in Integration Services Project

Question

When creating a new Integration Services Project in Visual Studio 2013 I can select the .NET framework to target. How can I see what .NET framework is being targeted on an existing project and potentially change it?

Answer 1

You need to open one of the Script Tasks and click the "Edit script..." button. This will open the script on a new instance of Visual Studio with the script in its own project. There you can change the properties of that project to modify the targeted framework for that particular Script Task.

Answer 2

There is no .NET Framework targeting for SSIS packages. However, there IS SQL Server version targeting. Prior to Visual Studio (VS) 2015, it was a bit of a mess: you could only target a specific version of SQL Server with a specific version of Visual Studio. For example:

• SQL 2008 = VS 2008
• SQL 2012 = VS 2012
• SQL 2014 = VS 2013

With the release of VS 2015, however, Microsoft alleviated some of the headache by introducing SQL Server targeting within VS by just right clicking on the solution, going to properties, and selecting the version of SQL Server that the SSIS package would run on. This is important because it determines what components are available to use.

Now, with that being said, there is .NET Framework targeting within script tasks/components. To read more about that, check my answer at:

SSIS Script Keeps Reverting To .Net Framework 4.5