SQL Server (SSIS package) call. NET DLL

There is both method to call. NET DLLs in SQL Server.

The first one is to use the SQL CLR but it had a lot of limit.

The second method is for use with SSIS package to call the. NET DLL. Now I'll show the process and the problem come accross with it.

1.Create a integration Services Project in your Visual Studio. If you can ' t find the integration Services Project Option, need to install SSDT and Ssdt-bi for Visual St Udio. Then you can use the script Task or script Component in the project. And you can call DLLs with it.

　　　　

　　　　

2. You can click on Edit Script To reference DLL in the pop-up Visual Studio project. Then you can use the DLL's method like the general Visual Studio.

　　　　

3. Then you can save your Script Task and run it.

　　　　

SQL Server (SSIS package) call. NET DLL