Visual Studio "no project supported by NuGet" error

Question

I am attempting to create a new SSIS package in Visual Studio and am getting this message when I try to open the NuGet Manager. I am using Visual Studio 2019 Version 16.11.33. This just started happening within the last couple of weeks.

Answer 1

You cannot use NuGet with SSIS. NuGet is for downloading packages for .NET applications. It doesn't support SSIS projects. While you can use a C#/VB script in SSIS it runs in a sandbox and won't have access to the assemblies that NuGet might have downloaded.

In fact, in order to use a third party assembly in SSIS you have to go through a series of steps:

• Ensure the assembly supports .NET 4 because that is the version of the DTS host the package runs under.
• The assembly must be strongly named by the publisher of the NuGet package.
• The assembly must be installed into the GAC on the development machine (for VS) and on the SSIS server (for runtime).
• You must add a reference to the GAC assembly using Project References inside the SSIS script task that needs it.

Answer 2

Hi @Gronli, Brad，

Nuget packages are not supported in SSIS script task/component. You need to download the assemblies manually from the GitHub repository.

Next, you should add these assemblies to the Global cache assembly (GAC):

• How to: Install an assembly into the global assembly cache
• Use Visual C# to install an assembly into the Global Assembly Cache

---You can refer to the following article for more guidance:

• Referencing Other Assemblies in Scripting Solutions

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.