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...]
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...]
How to Enable TLS 1.2 as the Default Security Protocol on Windows Servers
Transport Layer Security (TLS) are cryptographic protocols designed to provide communications security over a computer network, typically between a website and a browser. TLS 1.0 and its deprecated predecessor, SSL are vulnerable to some well-known security issues such as POODLE and BEAST attacks. According to NIST, these vulnerabilities cannot be fixed or patched, therefore all companies, … [Read more...]
How to Fix SMTP 550 5.7.1 Unable to Relay Error on Windows Server 2012 R2
Here is one way of fixing an SMTP error on Windows Server 2012 when you see an error message similar to the one below: Error Message Steps to Add Localhost to the SMTP Relay Launch IIS 6.0 Manager. Right-click on the STMP Server (on this example it's named default, but it could be named something else) and select Properties. Click on the Access tab and at the very bottom … [Read more...]