web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

CRM SSIS: Connection Manager vs C# SDK connection

(0) ShareShare
ReportReport
Posted on by

Hi all, some clarity on this would be greatly appreciated. First the essentials;

- SSIS package being developed in VS2012

- CRM CozyRoc Connection Manager installed to connect to our 2011 on-premise system

- Script component being written in C# (my organization prefers this approach and do not want to apply a Destination component for example)

- Using SDK to try and update/create records in CRM from our core system here

I am currently getting an error reading SystemIO.FileNotFoundException: Could not load file or assembley 'Microsoft.Xrm.Sdk, Version 5.0.0.0...


Investigating this has suggested I need to add an authentication/server connection element to the script but, being new to C# , I'm struggling to find a solution. I'm confused as to why a call to connect from the script component is necessary when we have a connection manager in place.

Any help/guidance on this would be greatly appreciated. Please note, I have found the pages related to creating/updating records plus serverconnection on the SDK. It just doesn't seem to work when I apply the suggested format.

Many thanks, Thom

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    Hi ,you need to add Microsoft.Xrm.Sdk.dll to the Global Assembly Cache (GAC) on the SSIS

    machine

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans