x

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 '09 at 11:38 AM in Default

Robert gravatar image

Robert
11 1 1 1

(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 '09 at 11:57 AM

Blackhawk-17 gravatar image

Blackhawk-17
11.8k 28 30 35

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

CEWII

more ▼

answered Nov 18 '09 at 12:05 AM

Elliott W gravatar image

Elliott W
26

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

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1816
x897

asked: Nov 04 '09 at 11:38 AM

Seen: 5805 times

Last Updated: Nov 04 '09 at 04:40 PM