Search code examples
ssispackage

SSIS package could not open global shared memory to communicate with performance DLL

I am working on a .dtsx file that reads from a database and outputs a flat file.

While testing the package, using SQL's Execute Package Utility, I got this warning:

Warning:
  Could not open global shared memory to communicate with performance DLL; 
  data flow performance counters are not available.  
  To resolve, run this package as an administrator, 
  or on the system's console.

In my research I got mixed messages as to how to deal with this.

One person said it is an issue with data types between the source and data conversion.

Another said it was merely a warning that can be ignored as long as you don't need performance counters (which I don't believe I do).

I also found where it is an issue on computers running Windows XP with no SQL Service packs, but I am on Windows 7.

Should I be concerned with this warning?

Solution

  • My understanding is that is UAC not allowing VS/BIDS access to the performance counters. For day-to-day package execution, you are fine. It is not impacting the ability of SSIS to run nor does it alter the outcome of data transformations.