Click here to Skip to main content
15,939,960 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

I need to prepare a dynamic pivot in SSIS. I can create it in SQL Server itself without using pivot component of ssis. But how it can be exported to Excel Destination is my problem. The number of columns are dynamic.

Please suggest


What I have tried:

I took table variable. If the number of columns are not changed then it is working fine. But if no of cols changed then I have problem

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900