Trying to figure out how to allow the user to select only Time in the data manager package and pass category=actuals and datasrc=imput.
I need the %SELECTION% variable to get set correctly. The output I'm hoping for would look like this: [CATEGORY] in (N'ACTUAL') and [TIMEID] in (N'20110300') and [DATASRC] in (N'INPUT'))
Here is a portion of the modify script:
PROMPT(SELECTINPUT,%SELECTION%,,"Please select the members to Clear and LOAD",%DIMS%)
How can I accomplish this?