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

more ▼

asked Nov 04, 2009 at 11:38 AM in Default

avatar image

11 1 1 3

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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?

more ▼

answered Nov 04, 2009 at 11:57 AM

avatar image

12k 30 35 42

(comments are locked)
10|1200 characters needed characters left

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..


more ▼

answered Nov 18, 2009 at 12:05 AM

avatar image

Elliott W
26 1 2 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Nov 04, 2009 at 11:38 AM

Seen: 6591 times

Last Updated: Nov 04, 2009 at 04:40 PM

Copyright 2016 Redgate Software. Privacy Policy