I ran into this problem today that didn't take a long time to resolve, but took me a little by surprise. Most of my SSIS packages use the Lookup transformation component to look up keys used in source systems and match them to the data warehouse. When SSIS packages fail at the Lookup component, the most common cause is that the source system's key does not exist in the data warehouse and must be added first. This time was different, however.
So I am borrowing this title from Mark Russinovich because this one took a while to figure out. I am writing this down mostly for my own records, but perhaps someone may find value in this encounter. Rewind to SQL Saturday 285 Atlanta 2014. At the end of the session, I get distracted and close … Continue reading Case of the Unexplained (Aelterman Edition): fingerprint readers, Windows Biometric Service and a few false turns towards VPN and dead SSD
If you're running Windows Server Update Services (WSUS) 3.0 Service Pack 2, have enabled SSL (the default I think) and now have Windows 8.1 Update clients, you'll find that those clients are unable to connect to the WSUS server to check for updates. I am writing this blog post to collect all symptoms and all … Continue reading Windows 8.1 Update Cannot Connect to SSL-Enabled WSUS 3 SP 2
I ran into this error today in SQL Server 2012. It was caused by having promoted a package-level connection manager to project-level and then copying and pasting some data flow components from one package to another in the same project. By copying the data flow components from one package to another, the SSIS designer also copied a … Continue reading SSIS 2012: Failure Saving Package: An Item With the Same Key Has Already Been Added
I spent a few hours today trying to understand why a number of computers in our (higher education computer lab) environment did not want to download updates for drivers using Lenovo's System Update tool. I tried disabling the usual suspects (particularly McAfee Anti-Virus 8.7i Enterprise and the Windows Firewall), but nothing made a difference. So then … Continue reading Software Interplay Issues: Netop Vision 7.2 and Lenovo System Update 4.01