April 2005 - Posts

DTS hangs after reading/writing 1000 rows
Tue, Apr 5 2005 10:36 PM

At one of my current projects I use DTS to get data in and out a Sql Server 2000 database. Because some of these processes take a while I show the progress messages of DTS in the StatusBar of my C# winapp.
I basically used the sample in a support article to build the handling of DTS from my client.
With some of the processes I experienced suddenly that DTS hangs after the first 1000 rows.
 
Because the OnProgressMessage event of a DTS Package fires every 1000 rows I guessed it had something to do with that event. So I turned off my handler for the event and that solved the problem.
Looking more into it I discovered that these problems occur when the event fires at a high frequency (many per second). In my case most of the importing or exporting to flat ASCII files happened (too) fast.
 
Despite the fact I spent quite a bit of time on it I found no better solution than the workaround. In my situation the workaround was sufficient but I'm still curious. So if someone knows a better solution please leave a remark.

by Edward van Steenderen | with no comments