Posted in Data Migration, SSIS

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

Advertisements

Author:

#enthusiastictechnologist #developer #consultant #freelancer #microsofttechnologies #dynamics365 #azure #datalover #datamigrationexpert #challenger #fitness-freak #blogger #technicaltrainer

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s