Announcements
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?
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156