I create the SSIS-Packet on Visual Studio 2019 and it runs on a SQL Server 2016 (13.0.5622.0). The Export runs with the 64-bit-Version.
No Errors, just one warning:
Warnung: 0x80049304 bei Data Flow, 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.
And Logging says further:
Informationen: 0x4004300B bei Data Flow, SSIS.Pipeline: "Excel-Ziel" wrote 127032 rows.
And mostly the Excel-Sheet is empty (no matter, if it runs in VS or directly on the Server with a SQL Server Agent Job).
I searched a lot of days in the Internet, but I found nothing, that would help me to solve my Problem.
Has anyone an idea?
(I'm gradeful for every proposal)
Thanks for help and i apologise fo my bad english.