Home Forums Data Warehousing Integration Services SQL task is not running when I pass one parameter via variable and the other 2 hard coded RE: SQL task is not running when I pass one parameter via variable and the other 2 hard coded

  • December 10, 2013 at 12:59 pm

    #1672426

    BypassPrepare is already set to true. I could probably\will probably have to use all parameters or none. The problem is it doesn't seem to like mixing parameters with hard coded lines.

    EG.

    Create Proc Getsomething

    @Value1 varchar(5),

    @Value2 varchar(5)

    AS

    ...

    i can't call this with a SQL task and have my statement = exec Getsomething ?, 'TODAY'

    and set my Parameter mapping to pass in my variable to parameter Name = 0 using a variable I am loading in the package.