• 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.