I came across an issue this week when loading a DLL to the SSIS integration runtime. Loading MSI packages is quite straightforward however, loading a single DLL proved to be quite a challenge.
According to the documentation https://docs.microsoft.com/en-us/azure/data-factory/how-to-configure-azure-ssis-ir-custom-setup you should provide a blob container in which you put a CMD task called main.cmd, in this you can then run your packages/dll to import them.
What I would like to achieve today is import the DLL for Analysis Services, which is the Microsoft.AnalysisServices.DLL.
We start off by creating a blob container and in this blob container we place the DLL which we need.
Then we will have to create a main.cmd which will load the DLL, we cannot use regsrv32 for this or msiexec, the way to go is using gacutil, which is included in the vs SDK.
The code below is the content for main.cmd, you will need to alter this for your own dll’s
| @echo off
xcopy /F /Y Microsoft.AnalysisServices.dll “%ProgramFiles%\Microsoft SQL Server\140\DTS\Tasks” REM error handling if %ERRORLEVEL% neq 0 ( echo Failed with ExitCode %ERRORLEVEL% exit /b %ERRORLEVEL%) echo “Complete copied to x64 folder” xcopy /F /Y Microsoft.AnalysisServices.dll “%ProgramFiles(x86)%\Microsoft SQL Server\140\DTS\Tasks” REM error handling if %ERRORLEVEL% neq 0 ( echo Failed with ExitCode %ERRORLEVEL% exit /b %ERRORLEVEL%) echo “Complete copied to x86 folder” gacutil\gacutil /i Microsoft.AnalysisServices.dll /f REM error handling if %ERRORLEVEL% neq 0 ( echo Failed with ExitCode %ERRORLEVEL% exit /b %ERRORLEVEL%) echo Successfully installed Analysis Services DLL Task. |
One of the first mistakes I made was naming the file Main.CMD, the start of the script is case sensitive so make sure you explicitly write main.cmd
The next issue I had was that I need the folder for gacutil.exe, to get around this I have added the gacutil.exe and all dependent files to the container which will be doing the custom setup.
This is what your container should look like.
In the background, any content you add to the container will be copied to a folder (C:\setup) on the VM’s hosting the SSIS IR, so in the main.cmd you are able to manipulate the environment by moving files around or loading new dll’s.
After these steps, you can use the DLL you loaded into the SSIS IR.
6 comments. Leave new
Hello, thanks for you post , i follow these steps but still have an error where executing package from the project deployed in server : renci.DLL not found ( no problem in desktop) . this is the code for my main.cmd
the code that i inseted in main.cmd :
gacutil /i Renci.SshNet.dll /f
gacutil /i SshNet.Security.Cryptography.dll /f
REM error handling
if %ERRORLEVEL% neq 0 (
echo Failed with ExitCode %ERRORLEVEL%
exit /b %ERRORLEVEL%)
echo Successfully installed Analysis Services DLL Task.
–> it can have errors , So if you have any links to help, please reply for me , thanks .
Hello thanks for your detailed post, i follow these steps but still have error when we execute package from the deployed project in server (azure) : he didn’t found the renci.DLL (so my file not installed) but i make the necessary (importing file dll , gacutil etc)
the code that i inseted in main.cmd :
gacutil /i Renci.SshNet.dll /f
gacutil /i SshNet.Security.Cryptography.dll /f
REM error handling
if %ERRORLEVEL% neq 0 (
echo Failed with ExitCode %ERRORLEVEL%
exit /b %ERRORLEVEL%)
echo Successfully installed Analysis Services DLL Task.
–> it can have errors , So if you have any links to help, please reply for me , thanks .
Hello Team,
Thanks for your detailed description But we still have the problem in cloud , my project is deplyed in Azure server and i should install the dll file (renci) in the global cache of IR SSIS . I follow your steps : I add a folder containing gacutil and the dll file in our specified blob storage , and i add the main.cmd in Azure with this code :
gacutil\gacutil /i Renci.SshNet.dll /f
gacutil\gacutil /i SshNet.Security.Cryptography.dll /f
I don’t need any messages. After I restart IR SSIS and make an execution for my package (with ssis calatog) and still have this error :
Could not load file or assembly ‘Renci.SshNet, Version=2016.0.0.0, Culture=neutral,
PublicKeyToken=1cee9f8bde3db106’ or one of its dependencies. The system cannot find the file specified.
I tried these solutions also with powershell :
https://stackoverflow.com/questions/45593418/register-dll-in-gac-cmd-or-powershell
https://www.andrewcbancroft.com/2015/12/16/using-powershell-to-install-a-dll-into-the-gac/
–> Not working
Please any help ,
Ahmed
Hello Team,
Thanks for your detailed description But we still have the problem in cloud , my project is deplyed in Azure server and i should install the dll file (renci) in the global cache of IR SSIS . I follow your steps : I add a folder containing gacutil and the dll file in our specified blob storage , and i add the main.cmd in Azure with this code :
gacutil\gacutil /i Renci.SshNet.dll /f
gacutil\gacutil /i SshNet.Security.Cryptography.dll /f
I don’t need any messages. After I restart IR SSIS and make an execution for my package (with ssis calatog) and still have this error :
Could not load file or assembly ‘Renci.SshNet, Version=2016.0.0.0, Culture=neutral,
PublicKeyToken=1cee9f8bde3db106’ or one of its dependencies. The system cannot find the file specified.
I tried these solutions also with powershell :
https://stackoverflow.com/questions/45593418/register-dll-in-gac-cmd-or-powershell
https://www.andrewcbancroft.com/2015/12/16/using-powershell-to-install-a-dll-into-the-gac/
–> Not working
Please any help ,
Best regards
Ahmed MEJRI
Hello Team,
Thanks for your detailed description But we still have the problem in cloud , my project is deplyed in Azure server and i should install the dll file (renci) in the global cache of IR SSIS . I follow your steps : I add a folder containing gacutil and the dll file in our specified blob storage , and i add the main.cmd in Azure with this code :
gacutil\gacutil /i Renci.SshNet.dll /f
gacutil\gacutil /i SshNet.Security.Cryptography.dll /f
I don’t need any messages. After I restart IR SSIS and make an execution for my package (with ssis calatog) and still have this error :
Could not load file or assembly ‘Renci.SshNet, Version=2016.0.0.0, Culture=neutral,
PublicKeyToken=1cee9f8bde3db106’ or one of its dependencies. The system cannot find the file specified.
I tried these solutions also with powershell :
https://stackoverflow.com/questions/45593418/register-dll-in-gac-cmd-or-powershell
https://www.andrewcbancroft.com/2015/12/16/using-powershell-to-install-a-dll-into-the-gac/
–> Not working
Please any help ,
Ahmed
Hi Ahmed,
My apologies for not replying faster. I have been having a lot of spam on the comments of my blog.
The message states that t cannot find the file, remember that the file is being put in c:/setup. as it is a copy from that storage folder.
try to find out where your GACUTIL is executing and what folder it is trying to get. What you could do is give the full path of your DLL and it might work.
Stijn