SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,643 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Good morning to all of you
I was wondering if it is possible in visual studio 2022 ssis to read the result of a pivot stored procedure and send it to an excel file.
My problem lies in the fact that the column names are never the same.
Do any of you know if this is possible?
Thank you very much
Marco Dell'Oca
read the result of a pivot stored procedure
If the Pivot query returns varying columns depending on parameter, then no: SSIS needs a fix resultset for further processing.