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, … Continue reading “Using Script Component to specify input value to OLE DB Source…
Continue Reading Nishant Rana’s Article on their blog
Using Script Component to specify input value to OLE DB Source Component in SSIS
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,…
Blog Syndicated with Nishant Rana’s Permission
More About This Author
Array
Dyn365CE16 July 2024Set an app (Model-driven or Canvas App) as a startup app – Power Apps Mobile
Dyn365CE16 July 2024Mobile Offline Profile – Select columns to be downloaded (Dynamics 365 / Model-driven apps)
Dyn365CE10 July 2024Perform Age calculation using Formula Columns in Dataverse / Dynamics 365
Dyn365CE8 July 2024Using Homogenous Batch / Bulk operation messages for improved performance – Data Migration / Dataverse