Some cases, we will be developing the SSIS package with third party component (custom dll’s) to connect or integrate with certain applications. In that case, while deploying the packages to different server, we need to install third party component (custom dll’s) as well. Rarely we will be getting error in deploy the package.
Simply we need to re-install the third party component ( Custom dll’s)
Cross check the custom dll’s which are installed properly in the respective folder
After installation of SQL server, BIDS (Business Intelligence Development Studio) and then we will be installing the third party component (custom dll’s). Sometimes custom dll’s get corrupted in the instance. Possibly new SQL server instance installation overrides or removes the custom dll’s.
There could be many reasons for dll’s corruption. Recently we have faced this issue and resolved it. Hope it will help somebody.
Do share with me your views or topics which would like to discuss on this