question

Raj More avatar image
Raj More asked

Dot Net Framework version for SSIS R2

How do I figure out the version of .Net framework used in my SSIS 2008 R2 package?
ssissql-server-2008-r2version.net-framework
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Oleg avatar image
Oleg answered
If your package was originally designed in SQL Server 2008 R2 then it probably uses whatever framework version your SSMS is using. To see this you can open SSMS, and then check the value of the **Microsoft .NET Framework** of the **About Microsoft SQL Server Management St**udio dialog accessible via **Help** --> **About** on the top menu. You can also open your package in BIDS and then right-click on the script task (under Control Flow) and choose **Edit** from the popup menu. Click on **Script** in the left frame and then click **Design Script** button. This will open the **MIcrosoft Visual Studio for Applications** IDE. In the **Project Explorer** you can select any of the available references, such as the reference to the **Microsoft.SqlServer.ScriptTask** and then look at its properties, which will include **RuntimeVersion**. If the value of RuntimeVersion is v.2.0.50727 then it is Framework 2.0 etc. Oleg
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.