SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

How often have you received the error below?

Error

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The…

Reconfigure an existing Integration Runtime on a Virtual Machine without Reinstalling

Cannot set the initialization properties for OLE DB provider “MSOLAP” for linked server “TABULAR”

Description

When querying a SSAS instance using a linked server on a remote server while the same user also have a RDP session…

Warning: Could not open global shared memory to communicate with performance DLL

Today I was busy with SSIS and came across this error

Warning: Could not open global shared memory to communicate with performance DLL;

QlikView — Open, Save, Close a QVW without reloading data using PowerShell

So you can open a QVW file from the command line with one of the following options

/r  Reload, save, close.
/rp Partial-Reload, save, close.
/l  Reload, leave open.
/p…

It worked on my machine

Downloading parquet files using the Azure Portal Data Explorer corrupts files…

Vague SSIS error message — SSIS Error Code DTS_E_PROCESSINPUTFAILED

So today I got the error message below

DFT Extract interface_RiskScorecard:Error: System.NullReferenceException: Object reference not set to an instance of an object.
 at…

SSIS Package opens with errors after installing Visual Studio 2010

Last week I installed Visual Studio Premium 2010, and today I had to open a SSIS 2008 package. To my dismay when I opened it I got the following error (Unable to instantiate XML DOM document, please verify that…

SQL SERVER — UDF — Function to Convert Text String to Title Case — Proper Case (via Journey to SQL Authority with Pinal Dave)

Really very useful! Copy, Paste, Execute and Use. Saved me a lot of time.

Procedure or function ‘GetOrder’ expects parameter ‘@ID’, which was not supplied.

Today I started a new method and and instead of doing the usual copy and paste code from one of my already working methods I just typed it as it is only 3 lines.