Data Flow Task just hangs and spins with Output Message

Bobby P 221 Reputation points
2020-12-04T20:16:08.127+00:00

So we have a SSIS Package that extracts from our VM and accesses our Azure SQL Database via a Linked Server for some of its data and then creates a .csv file that we then output via WinSCP.

When we tried to Productionize this Package and using a Service Account and SQL Server Authentication, when the SSIS Package gets to the Data Flow Task it just spins and spins and spins trying to run the SQL Server Stored Procedure to access the data via an OLE DB Source. Now I know this works because I can sign onto SSMS as the Service Account and manually run the SQL Server Stored Procedure and it runs in about a minute. When I look at the Output in Microsoft Visual Studio I see...

Data Flow Task, 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.

I found a couple of reference sites which indicate that you have to add the Service Account to the "Performance Counters" Group. I guess I would ask do you have to do that in Azure as well?

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f9492ba3-b6ac-4f2d-b52c-db86db5872e4/ssispipeline-warning-could-not-open-global-shared-memory-to-communicate-with-performance-dll?forum=sqlintegrationservices

I also found a discussion which refers to Admin Rights for the SSIS Account...

https://www.toolbox.com/tech/oracle/question/simple-package-error-in-ssis-110409/

https://microsoft.public.sqlserver.dts.narkive.com/uFck3GiG/could-not-open-global-shared-memory-to-communicate-w-performance

I honestly believe this is happening because of the way the Service Account is trying to attempt to access Azure SQL via the Linked Server.

Now tell me if this makes any sense...we have another SSIS Package that accesses [DynamicsCRM] in Azure SQL from the VM side...However...In this case and this SSIS Package, it does not access [DynamicsCRM] via a Linked Server. Instead, we set-up aliases on the VM side to access the Azure SQL Tables we needed.

Sooooo I think that's the path I'm going to go down here...Look at this other SSIS Package as a model that is accessing Azure SQL successfully via a SSIS Package using the same Service Account but try setting up aliases on the VM side.

Thoughts???

Thanks for your review and am hopeful for a reply and some insights.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,891 Reputation points
    2020-12-07T08:17:37.757+00:00

    Hi @Bobby P ,

    Warning: Could not open global shared memory to communicate with performance DLL;

    Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

    It seems that this warning does not affect the execution of ssis package.

    Hope the following links will be helpful:

    1.KB2496375 - FIX: "Could not open global shared memory to communicate with performance DLL" warning when you run an SSIS 2008 or SSIS 2008 R2 package on a computer that is running Windows XP

    2.SQL Server Integration Services SSIS Performance Tuning Techniques

    Best Regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues in November--What can I do if my transaction log is full?
    Hot issues in November--How to convert Profiler trace into a SQL Server table?