Using Script Component to specify input value to OLE DB Source Component in SSIS – Nishant Rana’s Weblog
Recently we had a requirement to write an SSIS package that will fetch the data from SQL Server and will insert it (or create records) into Dynamics 365 CE.
For connecting and fetching data from SQL Server, we were using OLE DB Source Component with data access mode as SQL Command which had one parameter, whose value we had to fetch from Dynamics 365 CE.
For passing the value to this parameter we had defined a variable within our Package named LastUpdateFromCRM.
Now as we wanted to set…
Continue Reading Nishant Rana’s Article on their blog
Using Script Component to specify input value to OLE DB Source Component in SSIS – Nishant Rana’s Weblog
Blog Syndicated with Nishant Rana’s Permission
More About This Author
Array
- Dyn365CE16 April 2024What will happen on changing the password of the user account used as the Owner of Cloud Flow and for Connection – Power Automate
- Dyn365CE15 April 2024Using Focused view in Dynamics 365
- Dyn365CE9 April 2024Associate activities (Email) with multiple related records – Dataverse / Dynamics 365
- Dyn365CE8 April 2024New Attachment features for Email – Dataverse / Dynamics 365