Hi Jyoti

Please follow the following steps :

1. Click on package properties. Set "DelayValidation" property to True.

The package will not validate tasks, connections, until they are executed.

2. Create an Excel connection in the connection manager. Browse to the target directory

and select the destination .xls filename or type it in. It doesn't matter if the file doesn't exist.

3. Select the Package and then go to SSIS -->Package Configurations --> A Wizard will popup

--> Select Enable Package Configurations

--> Click on Add

--> Specify Configuration File Directly option -- specify the dtsconfig file name

--> From the list on left Select

Connection Manager--> Excel File Connection --> ExcelFilePath

--> Save the Configuration File -- give it a name here

4. Create a Data flow Task

5. In the data flow select Excel source Task --> Set it to Excel file connection created earlier

6. Create a data reader destination task

7. Connection the two tasks and you are set.

In the dtsconfig file you can manually change the excel file name