all groups > sql server dts > august 2005 >
You're in the

sql server dts

group:

Integration Services PipelineBufferLeak


Integration Services PipelineBufferLeak steven.burris NO[at]SPAM gmail.com
8/12/2005 4:50:12 AM
sql server dts: I'm running an SSIS package via the "start without debugging" option in
BI Studio. The package brings in about 300,000 rows and calculates
about 30 million rows that it inserts. It's basically creating a table
of running totals based on a set of financial transcations. The
package should take about 2 hours to run on my machine. I'm reciving
PipelineBufferLeak errors in the log (descriptions below). Any ideas on
how to resolve this? Or should I just bump up my MaxErrorCount?

component "Merge Join 1" (1689) leaked a buffer with ID 12922 of type
13 with 0 rows and a reference count of .

component "Sort" (5146) leaked a buffer with ID 12924 of type 11 with 0
rows and a reference count of 1.

component "Script Component 1" (5266) leaked a buffer with ID 12926 of
type 18 with 0 rows and a reference count of 1.

An unidentified component leaked a buffer with ID 13075 of type 11 with
9637 rows and a reference count of 1.
RE: Integration Services PipelineBufferLeak Allan Mitchell
8/16/2005 12:52:02 AM
Steven you may want to post this up on the web forums @

http://forums.microsoft.com/msdn/default.aspx?ForumGroupID=19

Allan


[quoted text, click to view]
AddThis Social Bookmark Button