Wednesday, June 22, 2016

Fix: Unable to create the type with the name 'SPCRED'

Problem:
I tried to export one of the SSIS packages from Integration Services catalog. I got the below error
 
"Unable to create the type with the name 'SPCRED'. (Microsoft.SqlServer.ManagedDTS)"
 
Solution:
When I explore this issue, found that the package extracts data from SharePoint list. but we don't have inbuilt component in SSIS to fetch the data from SharePoint. So We need to use third party connecter which is exists in CodePlex "SharePoint List Source and Destination"
 
 
after Install this connector, I can export the  SSIS packages from Integration Services catalog without any issues.
 
Also, you can see this connector added in SSIS connection Manger
 
Note:
  • If it is not appeared in connection manager then you've to restart your Visual studio if it opened
  • If not appeared in connection Manager after restart your VS, then the version you installed is not compatible with your VS, so choose the Proper version and install it.

6 comments:

  1. I just see the post i am so happy the post of information's.So I have really enjoyed and reading your blogs for these posts.Any way I’ll be subscribing to your feed and I hope you post again soon.

    Dotnet Training in Chennai

    ReplyDelete
  2. Its very useful to me. Wonderful blog.. Thanks for sharing informative Post.

    Installment loans
    Payday loans
    Title loans

    ReplyDelete


  3. Its a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way.Thank you so much

    Personal Installment Loans
    Title Car loan
    Cash Advance Loan

    ReplyDelete

  4. Its a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way.Thank you so much

    Installment Loans Near Me
    Title loans Near Me
    Cash Advances Near Me

    ReplyDelete
  5. Thanks for all your efforts that you have put in this. very interesting information. i like with express my support of your ideas in your article, and looking forward to your next article.
    Iperidigi
    SEO Company in Chennai
    SEO Company in India

    ReplyDelete
  6. This information is impressive; I am inspired with your post writing style & how continuously you describe this topic.

    Eczema Treatment
    Psoriasis Oil
    Hyperpigmentation Treatment
    Herbal TonicThis information is impressive; I am inspired with your post writing style & how continuously you describe this topic.

    Eczema Treatment
    Psoriasis Oil
    Hyperpigmentation Treatment
    Herbal Tonic

    ReplyDelete