![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 84%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
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 Referencesinside the SSIS script task that needs it.
