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
How to fix Could not load file or assembly 'Ionic.Zip, Version=1.9.1.8, Culture=neutral, PublicKeyToken=edbe51ad942a3f5c' or one of its dependencies erro
![](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(300.8, 25%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Rohit Tandon
0
Reputation points
I am opening SSIS 2008 package on new Microsoft windows server 2019 datacenter ,for opening i am using sql server datatools 2019(VS2019)
I added all the references of external DLL's but still getting System.IO.FileNotFoundException: Could not load file or assembly 'Ionic.Zip, Version=1.9.1.8, Culture=neutral, PublicKeyToken=edbe51ad942a3f5c' or one of its dependencies. The system cannot find the file specified.
File name: 'Ionic.Zip, Version=1.9.1.8, Culture=neutral, PublicKeyToken=edbe51ad942a3f5c'
Remedies I tried:-
1)Removed all reference and added back and put external DLL at below location
C:\Program Files\Microsoft SQL Server\100\DTS\Binn
but still getting the same error during runtime
2)Added reference using Manage NugetPackage but still getting the same.
I need to run the updated SSIS package from sql agent job (2019 version)
Any leads or help is greatly appreciated.