This post will demonstrate one way to add custom logging to SSIS Package. This is still considered one of the better practice that comes in handy when we need to troubleshoot SSIS packages and track progress. There's no better way to explain the concept other than giving a simple case example on how to add it to a real SSIS package. For starter, the package in this example does a simple … [Read more...]
How to Backup IIS Manager Connections List on Windows
You've been using IIS Manager to manage remote IIS from your local computer. But how do you export the connections list if you move to a new computer or just to back it up if you lost all data? This post will show you how you can export and back up IIS Manager connections list on your local PC. All connections in IIS Manager are saved in a binary file called InetMgr.preferences and it … [Read more...]
How to Use System.Configuration.ConfigurationManager on .NET CORE
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 … [Read more...]