posted on Monday, April 18, 2005 2:35 PM
by
Knight_Reign
Out parameters in the Execute SQL Task...
One of the more strident complaints we've been receiving is the fact that the SQL Task didn't support out parameters on stored procedures. We listened.
Our crack developer, Mohammed spent some substantial time and effort on the issue and isolated the problem.
As it turns out, the SQL Task _did_ support out parameters. But, in some situations, the SQL Task had a bug in the portion of the code that retrieved the result into the parameter. Because of the way OLEDB returns multiple result sets, if the code doesn't consume all the results, and the out parameter value is one of the results, the out parameter won't get correctly set. For simple cases, stored procedures with only one result for example, the out parameters worked fine.
The bottom line is, ultimately, you should see this begin to work in the near future!
Thanks,
Universe.Earth.Software.Microsoft.SQLServer.IS.KirkHaselden