For various reasons such as patch application or software installation, a server needs to be rebooted. This simple step could potentially make or break the availability of your application. Just to have a quick information when your server was rebooted can help you in troubleshooting an issue. There are several ways to find this information. Using Command Prompt A quick way to do this is … [Read more...]
Gotcha in Executing SSIS from DTExec Command Line
This issue was found in a troubleshooting session in one batch job with one company. The company runs its SSIS using a third party enterprise software by calling dtexec command prompt utility (dtexec.exe) and passes the arguments from its interface. The enterprise suite calls the SSIS package using an Active Directory account (DOMAIN\BatchJob) and the SSIS package is comprised of a *.dtsx and … [Read more...]
How to Resolve ReferenceManagerPackage Error in Visual Studio 2019
If you encounter this error (see below) when you try to Add Reference in Visual Studio: You can take a look at the ActivityLog.xml file, but most of the time it's not necessary. Just for the sake of this example, let's open it up: Or you can view it with IE or XML viewer: For this particular case, Visual Studio cannot load … [Read more...]
How to Install Python on Windows Server
Python is an excellent general purpose language that can be used for batch processing and other tasks on your server. To install Python on Windows Server operating system, you just need to run the installer and use the simplest configuration. Steps to Install Python on Windows Server Operating System Download the installer (full as opposed to the web sintaller) and … [Read more...]
How to Add Custom Logging to SSIS Package
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...]