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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / where does the unpubli...
Microsoft Dynamics CRM (Archived)

where does the unpublished values will be stored for ms crm

(0) ShareShare
ReportReport
Posted on by sandeepc 5,514

recently we created optionsets from Nav to CRM through ssis package using cozyroc tool and the option set was showing in crm once package executed successfully but the data was not showing in database once we saved and published the data those option sets showed in data base

my question is where does the option set will be stored in database (sql) untill we publish it in crm??

*This post is locked for comments

I have the same question (0)
  • sandeepc Profile Picture
    sandeepc 5,514 on at

    Any suggestions

  • sandeepc Profile Picture
    sandeepc 5,514 on at

    does crm database stores or not any idea?

  • Verified answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    Hi Sandeep,

    Yes CRM database will store those data.

    You can retrieve unpublished information using metadata request.

    msdn.microsoft.com/.../gg334390.aspx

    msdn.microsoft.com/.../microsoft.crm.sdk.messages.retrieveunpublishedrequest.aspx

  • sandeepc Profile Picture
    sandeepc 5,514 on at

    hi goutam thanks for the reply  in which table does it stores data ???

  • sandeepc Profile Picture
    sandeepc 5,514 on at

    we are using crm on premise and we use sql data base

  • sandeepc Profile Picture
    sandeepc 5,514 on at

    any more suggestions about in which table the unpublished data will be stored in db

  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 1,032 Moderator on at

    Hi sandeepc,

    It depends on how you set up your destination components in SSIS. Once you have the data you can pass it into a CRM Destination Component or an OLE DB Destination component. Also, if you need to store the data in an intermediary table you can do this by uploading data from SSIS into SSMS.

  • sandeepc Profile Picture
    sandeepc 5,514 on at

    can we have for field level publish???

  • sandeepc Profile Picture
    sandeepc 5,514 on at

    usualy we have for account entity to pass it into a crm destiantion component now we need for option set field . can we acheive this

  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 1,032 Moderator on at

    Hi sandeepc,

    It is possible to set an Option Set field with a CRM Destination component. The easiest way to do this is by setting up a CRM Option Set Mapping Component, running that into a CRM Destination component, and mapping the Option Set field.

    You can map Option Set fields with CozyRoc, KingswaySoft, and other tools depending on your preference.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
ScottDurow Profile Picture

ScottDurow 2

#2
GJones Profile Picture

GJones 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans