Post reply

passing in a stored proc parameter at runtime

  • January 12, 2006 at 8:23 pm

    #76472

    I have an Execute SQL task which calls a stored procedure.  The sp has one input parameter that I'd like to define at runtime. 

    I'm familiar with using the Dynamic Properties task to configure connection properties (using an ini file). Can I use DP to also configure my input parameter?  In the DP task, under the Execute SQL task, I see a property called "InputGlobalVariableNames", and I've mapped it to an ini entry, but that's as far as I've gotten. 

    Am I even on the right track?

  • January 16, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • January 16, 2006 at 3:06 pm

    #615015

    Use your Dynamic Properties task to assign the passed value to a Global Variable. The use this Global Variable as an input parameter in the ExecuteSQL task.

     

    --------------------
    Colt 45 - the original point and click interface

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply