Hello Sql Fans!

I have some script in a DTS package that runs through a table and, when
appropriate, sends out an email containing the contents of a text field in
the table. This has been working fine until I decided to test the system
with about 70000 characters in the text field. The script in the package
does two things:

1) Sets a Recordset object up with the results of the appropriate records
2) Updates the table and sets the schedule date time of the appropriate
records to a date in the future. (these will be deleted after a successful
mail)

If the text is less then 7000 characters then this process works as planned.
Going over this limit on the production box, the DTS package returns with a
"timeout expired" error while trying to update the records. I can run the
update statement through Query Analyser but not through the script. The
script in Query Analyser takes way less then 30 seconds and even if I push
the command timeout to 60 seconds (yuck) I still get the problem.

The thing that confuses me even more is that this same script, with the same
amount of data, works fine on my development box (isn't that just always the
case!). I've checked service packs and both are running SP3. I've changed
the update query to a stored procedure but that doesn't help either.

If anyone has any ideas on this I would really appreciate it. I'm going a
bit mad trying to figure out the differences between the two boxes.

Thanks in advance,
Charles