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

could not open global shared memory to communicate with performance dll sql server 2012
how to run ssis package as administrator
warning 0x80049304
unable to bulk copy data. you may need to run this package as an administrator.
ssis cannot open the datafile

I am working on .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 xp with no SQL Service packs, but I am on Windows 7.

Should I be concerned with this warning?


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.

SSIS package could not open global shared memory to , Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To  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.


If you want to prevent this warning from occurring, you can add the user account used to execute the package (e.g. your account and/or the SQL Server Agent account) into the local group "Performance Monitor Users".

If this change is made for any services e.g. SQL Server Agent, the service will need to be restarted for the change to take effect.

Error executing SSIS Package, SSIS.Pipeline: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not  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. My package takes data from one source to a database destination using SQL Server Destination.


The @Nathan fix didn't work for me

What sorted it was running Visual Studio as administrator ... even though my account is in Local Administrators group

SSIS Warning, I'm busy rewriting DTS packages as SSIS packages. [SSIS.Pipeline] Warning: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. Could not open global shared memory to communicate with performance DLL. SQL Server SSIS : [SSIS.Pipeline] 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.


The "local administrators" group allows you to function with administrator rights when separately requested, such as "run as administrator". It does not mean that you run everything all the time with administrator rights

Warning: Could not open global shared memory to communicate , Warning: Could not open global shared memory to communicate with performance with performance DLL; data flow performance counters are not available. SSIS packages attempt to update performance counters on the  But at runtime it gave this very misleading error, which was caused by SSIS not copying across the Parameter Mapping. Share this: Click to share on LinkedIn (Opens in new window)


Simple package error in SSIS, [SSIS.Pipeline] Warning: Warning: Could not open:global shared memory to communicate with performance DLL; data flow performance counters are not  Warning: Could not open global shared memory to communicate with performance DLL; data flow performance are not available. To resolve, run this package as an administrator, or on the system’s console. So running BID/SSMS as administrator allows me to execute this package successfully.


Could not open global shared memory to communicate w, Discussion: Could not open global shared memory to communicate w/ performance I have a simple SSIS package executing perfectly in the BID Environment (on the Windows performance DLL; data flow performance are not available.


SSIS Warning: Could not open global shared memory to , 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 (SSIS