ssis dynamic file name and sheet name excel

[flobird]

Hi

new to SSIS

is there a script task that can be used in SSIS 2010

This task would have to find an excel file with a dynamic file name (note file name always begins with "Tender"***** don't know if this will help)

and dynamic sheet name (note sheet name always begins with "Sale"***** don't know if this will too)

and rename it before it begins the process? it will have to rename the file name to TenderProcess and Sheet name to SaleFigures.

This is because I have a script task that I will use later on in the SSIS package that finds a specific excel file in a folder and moves it

please help

 

[Motlatjo]

Hi flobird

To rename sheet

http://vijirajkumar.blogspot.co.za/2010/04/rename-excel-sheet-net.html

To rename the file use SSIS File System Task
Use Foreach Loop Container to load files that begins with "Tender..."

Hope that can help