I am facing an issue in my package.
I have a transaction table wherein i get data date wise daily, i am creating a pivot of the table through TSQL.
This is all working fine.
Now i have to export the pivot data into flat file and mail to some mailing list.
when im exporting the data, i'm not able to retrieve the column headers since my column are dynamic. i am not able to map.
please help me in this. I m struggling with dynamic column mapping