Saturday, 6 February 2010
SSIS : ADO.NET Stored Procedure Performance
Andy Leonard's article 'SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers' has been updated. One of the new parts shows a considerable performance improvement when using an ADO.NET connection and setting IsQueryStoredProcedure to true (when using SPs).
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment