When testing my SSIS package I received the following message:
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.
I corrected this by using OLE DB Destination instead of SQL Server
Destination as my target detination object.