Hello Everyone,

I have a DTS package that has always worked perfectly except it keeps
failing sometimes, but it only fails when it tries to copy a
large(about > 90mb) text file contents from source to destination file.
For file size less then 50 mb it has always worked perfectly fine, but
sometimes we have files greater then 100 mb and that's we the below
code fails. Is there any limit on .write method on FilesystemObject or
am i missing something very obvious here.

CODE with DTS package ActiveXScript

sSourceFile = "a.csv"
sDestinationFile = "b.csv"
Set oCFSO = CreateObject("Scripting.FileSystemObject")

Set oCFile = oCFSO.OpenTextFile(sSourceFile, 1,,-2)
strContents = oCFile.ReadAll
oCFile.close

Set oCFile = oCFSO.OpenTextFile(sDestinationFile, 2,True,0)
oCFile.Write(strContents)
oCFile.close

' Clean Up
Set oCFile = Nothing
Set oCFSO = Nothing

Error message i get is as follows

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:ActiveX Scripting encountered a Run Time Error
during the execution of the script.
Step Error code: 800403FE
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4500

Can anybody please help me on above problem, as i need to fix it very
urgently.

Regards
Nirav Lulla