SSIS source Pivot stored procedure

Marco Dell'Oca 201 Reputation points
2023-06-24T15:44:26.7333333+00:00

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,643 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
247 questions
{count} votes

Accepted answer
  1. Olaf Helper 46,041 Reputation points
    2023-06-26T05:33:35.12+00:00

    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.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.