I'd like to use the Stored procedure component with an SP that contains dynamic SQL. In fact I create a result set with combined usage of XML Path e Pivot like
User. Tfr_2013. TFR_2014 Tfr_2015. Tfr_2016 .............
User1. 1345. 1578. 1890. 1958
User2. 2345. 3456. 4589. 5678
Where first column and at least one other column are mandatory, but I can't definitely know in advance the real number of column. As SP Component needs output parameters coupling, I suspect that it is necessary to create a Custom Component.
Someone had a similar problem or has a bright idea .