I need to create a script to clear data in a DEV system from a particular junction.
Basically, I need the user to enter a CATEGORY, ENTITY and TIME which will then be used to delete all data in a particular table which meetes those criteria.
I tried to write it in SSIS, but can't get a user input box.
Also, Stored Procedures are not designed to open input boxes for these entries.
Therefore, is there a way to do this in BPC script logic?
I believe that I might be able to write either a Stored Procedure or DTSX package and then pass data from BPC Run Package?
If this is correct, how would I go about it?
Also, would it be possible to read the DISTINCT entries for Category, Time and Entity and present as a dropdown list? (It doesn't matter too much if not, a manual entry would have to do).
I will admit that I have no experience of script logc, so any docments and/or pointers would be appreciated.