Trying to run simple SSIS package from BIDS

Hello, I am trying to run a simple package to import an Excel sheet to SQL Server 2008 using BIDS. In the Progress tab I continually get this 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. I have also ran it using the sa account with the same result. Any ideas would be greatly appreciated. Robert

asked Nov 04 '09 at 11:38 AM in Default

Robert
11 ● 1 ● 1 ● 1

(comments are locked)

2 answers:

Start by going over this article: DBCC MEMORYSTATUS

This may at least provide a starting point of what is being consumed and allow us to troubleshoot further.

What O/S is SQL running on?
What is the size of the data being consumed?
How much physical RAM and how much allocated to SQL?
Have you tried running the SQL service as LOCAL SYSTEM or another O/S-level administrator? (It could be a simple user right not granted to the service account that is required to access the DLLs)

All this being said... does the package execute? This seems to indicate that it couldn't show progress in Performance Monitor. That is not necessarily an issue unless you need to monitor it for some reason. I agree that it is troubling to see a warning but is it a show-stopper at this time?

answered Nov 04 '09 at 11:57 AM

Blackhawk-17
10.5k ● 23 ● 29 ● 34

(comments are locked)

I'm guessing a bit but you either did your development on Windows Vista or Windows Server 2008. When you open BIDS it used to display a message saying that you really should run it as an Administrator.. I believe the resolution is to right click on the BIDS icon and click the Run As Administrator option and then I think this will go away..

CEWII

answered Nov 18 '09 at 12:05 AM