Recently, while working on Visual Studio 2017, when we wanted to launch Package Manager Console from Quick Launch Window, we got the below error message "The type initializer for 'System.Management.Automation.Runspaces.InitialSessionState' threw an exception". To fix this issue, we installed PowerShell Tools for Visual Studio 2017 from here and restarted Visual Studio. After doing this, we were able … Continue reading Visual Studio 2017: Package Manager Console gives error “The type initializer for ‘System.Management.Automation.Runspaces.InitialSessionState’ threw an exception”
In this blog post, we'll see how to execute Stored Procedure in Azure SQL Database inside Azure SQL Server. Let's go through the steps to see it in action. Login to Azure Portal.Click Create a resource --> Databases --> SQL Database. Give a unique name to the Azure SQL Database. Click on Server field to … Continue reading Azure: Execute Stored Procedure using Azure Data Factory
In this blog post, we'll see how to copy data of an entity "Contact" in D365 CE to Azure SQL Database. Let's follow the below steps to see it in action. Login to Azure portal.Create Azure SQL Database where we need to copy the data. Click Create a resource --> Databases --> SQL Database Give … Continue reading Azure: Copy Data from D365 CE to Azure SQL Database using Azure Data Factory
In the previous post, we created the required Azure resources. In the last step of the previous post, we created Azure SSIS IR which is basically responsible for creating SSISDB in the Azure SQL Server where we'll deploy the SSIS package. In this demo, we are going to execute a SSIS package which will load … Continue reading Azure: Execute SSIS Package using Azure Data Factory – Part 2
In this blog post series, we'll learn how to execute SSIS package using Azure Data Factory. This topic is divided into 2 parts: In the first part we'll create the required Azure resources and in the second part we'll see how to deploy and execute the package. To begin we need following Azure resources: Azure … Continue reading Azure: Execute SSIS Package using Azure Data Factory – Part 1
Recently, while working on Azure SQL Server to execute SSIS package, we found a strange issue. We created the Azure SQL Server from Azure Portal. We designed the SSIS package using SSDT. To deploy package to Azure SQL Server and execute there we need Azure-SSIS Integration Runtime(Azure-SSIS IR) to be setup. We created Azure Data … Continue reading SSMS: Integration Services Catalog node not visible
Plug-in on pre-validation
Recently we had a requirement to delete the Account record without deleting the associated Contact records.
If we try deleting the account record we’d get the following message box
The relationship definition can’t be updated as well to achieve this
So, we wrote a plugin on the pre-validation stage of pre-delete event of Account, which will retrieve and loop through all the child contact records and set its parent customer field as null.
In case of pre-operation the child records were not available.
Another practical scenario
Hope it helps..