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
- Dyn365CE30 April 2024Use Geolocation Settings for Location Tracking and Auditing – Dynamics 365 Field Service
- Dyn365CE29 April 2024Fix the trigger – Microsoft.OData.ODataException: A binary operator with incompatible types was detected. Found operand types ‘Edm.Guid’ and ‘Edm.String’ for operator kind ‘Equal’ (Power Automate / Dataverse)
- Dyn365CE23 April 2024Portal does not load and displays “Server Error” or shows “Getting set up.. This might take a while” message -Portal Startup Issue (PowerApps Portal)
- Dyn365CE22 April 2024Versioning and Drafts for Solution-based Cloud Flows – Power Automate