Why SSIS Script is losing NuGet package and references after I close and reopen the script?

25 views Asked by At

I have written a script in SSIS script task editor to read csv files using CsvHelper. While executing the package it is throwing the following error:

'Could not load file or assembly 'Microsoft.Bcl.HashCode, Version=1.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The system cannot find the file specified.' >

error

I have removed and reinstalled and even tried updating the packages (Microsoft.Bcl.HashCode, System.Memory) for the references with warning signs (yellow triangles) on reference list (image). For the time being, it gets fixed but when I close the script and try to execute the package or open the script editor again it returns to the previous state.

NB: I am using SSIS 2017, target framework 4.7

I would be thankful for any workaround suggestions.

reference list

0

There are 0 answers