Skip to Content
Former Member
Sep 30, 2011 at 02:11 PM

Need help creating script to clear data with user inputs


Hi experts.

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.