Can anyone help/guide on how to change the filefeed name

This message has been edited. Last edited by: Tamra,

Could you elaborate on what you mean by "filefeed?"

If it's the source synonym in a flow you can right click on it and select change source.

If it's the DATASET name in a synonym you can edit or paramaterize it there.

Filefeed i mean the one where my data is .

In my case I have data in an excel file named 'dataset' and with that i create my synonym

When i get new set of data or if i have to point to another dataset named 'dataset2'

how do i do this?

There are two adapters for reading Excel data, Excel (via ODBC) and Excel (via direct retreival). I'm going to guess that you are using the latter.

Open the synoynm in the synonym editor, right click on its name and select properties. There you will see under General an attibute called DATASET that should have the location and name of your workbook.

If this is a one time change you can change the name to another workbook that has the same layout and save the synonym.

If you want to change the workbook dynamically you can right click on DATASET and select Paramertize value. That will replace the value with a global variable name. Save the synonym

Open your data flow and click on the process flow tab. Add a Set variables object between Start and Data Flow and connect it. Now you can set the value for the variable as needed.