Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to export the data into flat file because of Dynamic Column Mapping Expand / Collapse
Author
Message
Posted Thursday, October 3, 2013 5:05 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, December 18, 2014 11:45 PM
Points: 81, Visits: 104
Hi Folks,

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


Regards,
Deepika Goyal


Post #1501117
Posted Thursday, October 3, 2013 10:25 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, December 18, 2014 11:45 PM
Points: 81, Visits: 104
Please reply someone...

Please
Post #1501415
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse