We have a data flow that users want to be able to enter parameters for, such as Month and Year to pull data for, select a particular external data file to process the flow against at runtime, or provide the name they would like the resultant dataset to be called when it is stored.
There is no way for the user to provide that information to the data flow without either editing the flow (cumbersome), or setting up a complex database table scheme (which requires the users to have write access to a database, which can be problematic).
Data Flows should provide a Prompting functionality, requesting information from the user via a configurable prompt,and storing the answer in a variable that is accessible to appropriate steps in the Data Flow.
This would make the process much more user friendly and allow for easier management of user data analysis needs.
