• polkadot - Thursday, June 22, 2017 5:50 PM

    while you two were having a little secret code language conversation I was pulling my hair out with parameter passing to exec sql task. Man alive.

    No need to be unpleasant.
    If you reread your own post

    Turns out, that since I was assigning DATE datatype to @FromDate parameter, it was not passing the expression to Exec SQL Query as '2017-06-01 00:00:00.000'. After I changed datatype of parameter to FLOAT it did. 


    You will see that sounds like you have resolved your problem. If you have not, try explaining why.