> I created a custom script source component to pull data from a dirty
> pervasive 2000i DB service pack4.
>
> Heres the problem my component will pull 425 rows of data but it will
> do this only if I set my deffaultBufferMaxRows property to a small
> number like 17. It will not pull more than 425 it hang and pull no
> more and if I leave my deffaultBufferMaxRows to the default value of
> 10000 it gives an error saying that the 'the connection has been
> disabled" also if i only output some of the columns it work fine
> getting all the data to completion.
>
> The table I am importing has 140 columns 490233 rows and various data
> types. The max number of columns I was able to pull without error was
> 132
>

"Allan Mitchell" wrote:

> Hello rhjDBA,
>
> Could this be a Driver issue. What type of connection manager are you using
> to connect to Pervasive?
>
>
> Regards
>
> Allan Mitchell
> Konesans Ltd
> T +44 7966 476 572
> F +44 2071 008 479
> http://www.konesans.com
>
> > I created a custom script source component to pull data from a dirty
> > pervasive 2000i DB service pack4.
> >
> > Heres the problem my component will pull 425 rows of data but it will
> > do this only if I set my deffaultBufferMaxRows property to a small
> > number like 17. It will not pull more than 425 it hang and pull no
> > more and if I leave my deffaultBufferMaxRows to the default value of
> > 10000 it gives an error saying that the 'the connection has been
> > disabled" also if i only output some of the columns it work fine
> > getting all the data to completion.
> >
> > The table I am importing has 140 columns 490233 rows and various data
> > types. The max number of columns I was able to pull without error was
> > 132
> >
>
>