Hi,

Please go through the following links. You will get a solution.

http://www.bigresource.com/MS_SQL--SSIS-Dynamic-Excel-File-Name--HbPRu1XN.html

http://dbaspot.com/forums/ms-sqlserver/357322-excel-template-required-export-ssis.html

with regards

SSSK