Guys,

I am using copyfromrecordset method to export data to excel using DTS.
However, there is a text column which is not getting exported
correctly. DTS errors out with "ActiveX scripting runtime error". Then
I tried casting the column with 900 characters and it works but when I
do 1000 characters it errors out again.

Do you guys have any idea of tackling this problem. Any help will be
greatly appreciated.

Thanks in advance.

Deepak