Announcements
No record found.
I am trying to get some records from the mscrm online in the VSTA project that opens up when you click Edit Script button inside Script Task Editor for SSIS package. I am following a mix of these two tutorials https://nishantrana.me/2020/10/19/connect-to-dynamics-365-through-script-component-ssis/ and https://community.dynamics.com/crm/b/nishantranaweblog/posts/metadata-contains-a-reference-that-cannot-be-resolved-https-orgname-crm8-dynamics-com-xrmservices-2011-organization-svc-wsdl-amp-sdkversion-9-error-in-dynamics-365 . But I am still getting weird errors. The problem being this project seems to be automatically created so I can't install Nuget Packages like a normal project and I am having to old code. Could someone please copy paste the kind of code they have used for an SSIS script project to query CRM? Perhaps even using Kingswaysoft libraries? Thank you very much!
Correction to above: ....The problem being this project seems to be automatically created so I can't install Nuget Packages like a normal project so I am having to add xrm.sdk to gac manually etc as mentioned in the tutorial but I am still getting error after error. Could someone please copy paste the kind of C# code they have used for an SSIS script project to query CRM? Perhaps even using Kingswaysoft libraries? Thank you very much!
SSIS VSTA Project is not a full .NET development environment, it does not really have support for Nuget Packages. If you need to use a particular Nuget library, you would have to extract the the library using a full VS project, and then add as a .NET library reference to the VSTA project. The VSTA project is a fairly restricted environment, you have to be creative sometimes when working with it.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
ManoVerse 184 Super User 2026 Season 1
11manish 125
CU11031447-0 100
