sql - How to split table data into separately named Excel files with 'datepart' using an SSIS package? -
i followed great link below accomplish 90% of work. when created excel files using 'dateparts' created excel files, did not load data files. how split table data separate named excel files using ssis package? example: link above showed how create north , south , template excel files table values. in case want create north_20130613 , south_20130613 , template_20130613 . created these files also, unable load data them(extended 'datepart'). i know how append everyday data files. usually load data file general name , rename file datapart afterwards.