gbritton1 (4/15/2014)
Robert Frasca (4/14/2014)
From what I can see, that's only true for parameters passed to stored procedures. .Actually its not so much that but the difference between an Execute SQL Task in the Control Flow and and OLE DB transformation in the Data Flow. For some crazy reason, these two look very different, especially in the area of parameter mapping. I wrongly assumed the former.
An execute SQL task is different from a source because the execute SQL task doesn't care about metadata and resultsets retrieved, but for the source this is very important.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP