HI,
I am using SSIS package to update data from dynamics crm to Database. I have connected dynamics crm using application id and secret. How to get connected dynamics user GUID in derived column?
Thanks,
Pavan N
HI,
I am using SSIS package to update data from dynamics crm to Database. I have connected dynamics crm using application id and secret. How to get connected dynamics user GUID in derived column?
Thanks,
Pavan N
Hello,
You can do a query to the systemuser table and user equal-userid condition - one record returned will be your app user so you can get your id, put it to the variable and use it in your package.
Good luck.
I want to pass this information back to CRM. who is updating the record. its a custom field.
Just question why you want to use connected user id in SSIS?
No, due to we are using different application id for production environment.
Did you tried by hardcoding GUID?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,558 Super User 2024 Season 2
Martin Dráb 228,645 Most Valuable Professional
nmaenpaa 101,148