Problem with an SSIS script task in Visual Studio

Question

Hello,

I would like to create a scripting task in Microsoft Visual C# 2012 in SSIS via Visual studio 2015.
However previously I had two tasks available in the toolkit (Microsoft Visual C# 2012 and Microsoft Visual C# 2015) but now I only have the Microsoft Visual C# 2015 scripting task available. What is this related to please? How to get the script task for Microsoft Visual C# 2012?
Knowing that in existing SSIS packages I have old tasks in Microsoft Visual C# 2012 which I can access without any problem and in other packages, impossible, I get the attached error.

Thank you in advance for your help.

Answer 1

Hi @Jérémy GRESLON ,

You are using somewhat outdated software for SSIS development.

It is highly recommended to use the following software:

1. Visual Studio 2019, any edition. Including free of charge Community Edition.
2. SQL Server Integration Services Projects extension for VS2019. v.3.16

Such setup allows to develop SSIS projects targeting SSIS run-time on a server versions: 2012, 2014, 2016, 2017, 2019.

Answer 2

It sounds like the Microsoft Visual C# 2012 script task has been removed or disabled in your installation of Visual Studio 2015. This could be due to an update or change in your Visual Studio installation.

To re-enable the Microsoft Visual C# 2012 script task, you can try the following steps:

1. Close Visual Studio.
2. Open the Visual Studio Installer from the Windows Start menu.
3. Select the installation of Visual Studio that you are using.
4. Click the Modify button.
5. In the Modify screen, expand the Programming Languages node and select the option for C#.
6. Check the box for "Integration Services Project support".
7. Click the Modify button to apply the changes.
8. This should add the Microsoft Visual C# 2012 script task back to the SSIS Toolbox in Visual Studio.

If these steps do not work, it is possible that the Microsoft Visual C# 2012 script task has been removed from your installation of Visual Studio. In that case, you may need to install an earlier version of Visual Studio or use a different tool to create the script task.