SSIS export to Excel, Sheet is empty but logging says "Excel-Ziel" wrote 127032 rows, no Errors, just 1 Warning

Question

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.

Answer 1

Hi,
I updated the extenstion 'SQL Server Integration Service Projects' to V3.10 and tried it again.
Same result. SSIS wrote more then 12.000 rows, but Excel-Sheet is still empty.

Best regards
Sabine