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.

You may see the above error if you are using the SQL server Destination in your SSIS package.

Sql server Destination cannot be used in packages that access a SQL Server database on a remote server. Instead use the OLEDB destination.

Things to note for SQL Server Destination

a. It offers the same speed as the Bulk Insert Operation.
b. It does not support Error Output.

For more information please check msdn

Posted January 17, 2010 by Vivek. Comments and trackbacks are open. Follow the comments feed.
Filed under:
Tagged with: , .

Leave a Reply

←
→