April 22, 2014 at 3:10 am
Hi
Getting the following warning in SSIS - SQL 2012:
[SSIS.Pipeline] 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.
Microsoft had a fix for SQL Server 2008.
Does anyone know how to get around this in SQL 2012?
Thanks in advance
April 22, 2014 at 4:01 am
Nats007 (4/22/2014)
HiGetting the following warning in SSIS - SQL 2012:
[SSIS.Pipeline] 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.
Microsoft had a fix for SQL Server 2008.
Does anyone know how to get around this in SQL 2012?
Thanks in advance
Change the destination to OLE DB Destination to get this working.
😎
December 23, 2014 at 3:57 am
I also get this error on SQL 2012, I am using OLEDB Destinations. I am trying to run 5 inserts at the same time, is the issue just pointing to a lack of memory then?
December 23, 2014 at 2:57 pm
Andre 425568 (12/23/2014)
I also get this error on SQL 2012, I am using OLEDB Destinations. I am trying to run 5 inserts at the same time, is the issue just pointing to a lack of memory then?
No, the shared memory access is only available to processes running on the same system as the database server and with the appropriate priveledges, has (almost) nothing to do with the resources on the system. Is the package running on the same system as the database server and is the process owner (user credentials) a member of Administrators?
😎
December 23, 2014 at 8:34 pm
Looks like I missed something, is running on same server, the package was running to SQL server destination, which I have started moving away from
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply