When you need to convert an existing .NET Framework Console application to .NET Core, there's one pending question that is kept being asked. Can you still use the System.Configuration and App.config (XML) configuration instead of using the new Appsettings.json file instead? There's always a need for a most robust configuration file and with JSON, it offers more flexibility and scalability but … [Read more...]
How to Check Installed .NET Core Version
This is the way to determine what version of .NET Core is installed on your machine (or if it's not installed): Launch Windows PowerShell. Runtime SDK In the following example, you can see that .NET Core 2.1.2 Runtime is installed, but the SDK is not installed with the following error message: Otherwise, it will look more like the next screenshot: When … [Read more...]
How to Create SSIS Package in Visual Studio 2017
This posting will show you how to create an SSIS package using the legacy package deployment model in Visual Studio 2017. Please be sure before you do anything that you have SQL Server Data Tools for Visual Studio 2017 installed. You can find the SSDT download link below. Install it within the instance of your Visual Studio instead of creating a new one. With SSDT, you will be able to design and … [Read more...]
How to Build SSIS Package for Different SQL Server Version with Visual Studio 2017 and SSDT
After deploying an SSIS package built with Visual Studio 2017, we encountered a surprise when running it via a Command Prompt: Pay attention to this section of error message: Description: Package migration from version 8 to version 6 failed with error 0xC001700A "The version number in the package is not valid. The version number cannot be greater than current version … [Read more...]
How to Troubleshoot IIS 500 Error for ASP Websites
You try to load your classic ASP (Active Server Pages) website and all you can see in your browser is the all too familiar display of 500 Internal Server Error. What is 500 Internal Server Error First of all, the 500 Internal Server Error is a very general HTTP status code that indicates something has gone wrong on the web server without any specifics on the exact problem. This … [Read more...]