Strange Requirement

hi all,

i have strange requirement need advice.first of let me explain current scenario.

1> have ssis package schedule job , runs daily per schedules.

this package generates files particular location , these files generated using procedure.

now procedure been called in ssis package , executed.but requirement such have generate  data based on quarter.

say q1,!2,q3,q4 passed parameter , executed.

now new requirement whenever user tries execute job manually right cliking on job name. prompt has provided such user shud able select quarter , selected quarted must sent parameter ssis package.

my question is possible generate prompt kind of thing whenever user tries excute job sql server manully ?

please advice me on this.

---

please have on comment

i have code , iits wrking fine me

public function promptforparams() scriptresults

        dim response string
        dim spidint string

        ' default task output failure
        dts.taskresult = scriptresults.failure

        response = inputbox("specify quarter u need package executed ")

        if response = string.empty then
            msgbox("cancelled! ", msgboxstyle.okonly, packagename)
            return scriptresults.failure
        end if

        ' if integer.tryparse(response, spidint) , spidint > 0 then
        'dts.variables("spid").value = spidint
        'else
        spidint = response
        'msgbox("u have selected these quarters " & spidint, msgboxstyle.critical, packagename)
        'system.windows.forms.messagebox.show("u have selected these quarters" & "'" & response & "'".tostring())
        'return scriptresults.failure
        'end if
        dts.variables("values").value = spidint
        return scriptresults.success
    end function

---

please have on comment

SQL Server  >  SQL Server Integration Services