Displaying posts written in

January 2010

Jan
17
2010
Business Intelligence, SSIS By Vivek | No comments yet

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