March 30, 2011 at 12:46 pm
I am getting following error.
[SSIS.Pipeline] 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.
Anyone have any idea that how to resolve it??
Thanks In advance.
March 30, 2011 at 2:19 pm
What version of SSIS are you running? What OS? I know you posted in the 2005 SSIS Forum but we do not have a 2008 Forum and I saw you posted a similar question in the 2008/General Forum.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 31, 2011 at 12:45 am
Are you using the SQLServer Destination? If yes, it could be a permission issue:
Try using the OLE DB Destination instead.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 31, 2011 at 7:54 am
Thanks for your quick response.
I am using SSIS 2008.
I gatheribng the data from two server(linked server) and loading it into Excel.
My destination is Excel Destination.
And It used to be worked perfect but I ran it yesterday and Its returning more than 18000 rows from more than 6 tables.
March 31, 2011 at 8:06 am
you say that you are getting an Error, however the log entry you posted is a Warning and should not stop the data from loading.
is your package loading the data into excel as expected?
or are you simply trying to remove the posted warning?
March 31, 2011 at 8:42 am
No Its not loading anu data into the Excel Sheet.
Package continious running.
March 31, 2011 at 8:44 am
Are there any error messages in the Exectuion Results?
March 31, 2011 at 2:41 pm
No there is no error in the execution tree.
April 1, 2011 at 3:26 am
so the package keeps on running but no data is written to excel?
is it possible that you are writing a huge amount of data and it needs to take time?
perhaps put a data watcher before the excel destination to see what is getting sent there.
May 27, 2011 at 2:55 am
Hi,
We also get this warning in our Data Flow Tasks where we use Flat File Source and the OLE DB destionation:
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.
We use the following version:
SELECT @@VERSION
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1765.0 (X64) Feb 2 2011 17:33:22 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )
Any ideas on how to solve this?
// Jon
August 4, 2011 at 3:42 am
Probably a bit late to reply but the message: [SSIS.Pipeline] Warning: Warning: Could not open global shared memory to communicate with performance DLL is just a warning and if you run the package as an administrator it should go away. Right click on SQL Sever Business Intellegence Development Studio and select run as administrator.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply