Unable to create the type with the name ‘CRM’ (Microsoft.SqlServer.ManagedDTS)

Case

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.

Resolution

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

Reason

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

1 thought on “Unable to create the type with the name ‘CRM’ (Microsoft.SqlServer.ManagedDTS)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: