Viewing 6 posts - 1 through 6 (of 6 total)
Cheers thanks Grant.
October 6, 2011 at 1:59 pm
Thanks very much SSCrazy. That's an excellent article and was indeed the problem. Modifying with recompile resulted in execution of 18 secs which is slightly longer than the disabling method...
October 5, 2011 at 2:51 pm
Thank you for your patience. I have found this article http://www.mssqltips.com/tip.asp?tip=1405 which will hopefully resolve this for me.
regards,
Graham
July 28, 2011 at 8:57 pm
Mmm that may be it. I created a variable in the package (right click in Control Flow then Variable) - Is Environmental Variable something different to that?
July 28, 2011 at 8:47 pm
Thank you Ghanta. So "implemented correctly" is the key - anything obvious I have missed?
July 28, 2011 at 8:34 pm
Viewing 6 posts - 1 through 6 (of 6 total)