Pipeline buffer leaks

Any tips on how to deal with pipeline buffer leaks that are appearing when looping round a package multiple times. Also any information on whether tweaking DefaultBufferRows / Size or threads would be helpful...

(this is all stuff that either worked or wasn't as bad in the Dec CTP.. so much for progress....)

[312 byte] By [GiriT] at [2008-2-10]

«« ArgumentOutOfRangeException when running .Net 1.1 compiled code on .Net 2.0
»» VC++ Where are the Managed data Container functions please?

# 1

This was a bug that has been fixed. There is no work around for this in the June CTP, but it will be fixed in the next CTP.
Tweeking the settings won't help. The problem is a setting is being retained from one execution of the pipeline to the next and not getting reset.
My only suggestion for the near term, until the fix is in, would be to put the pipeline into a sub-package and executed it in a loop. Lame, yes. I have no other suggestions, apologies.

KirkHaselden at 2007-9-8 >

top of Msdn Tech,SQL Server,SQL Server Integration Services...

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech