Dear,
I've created a DTS package to transfer data. For each step of pakage I'd like to catch up the error message and write it into one file. I've tried to add one active script after each step (on failure).
I coded as below
...
Set Myfile = fso.CreateTextFile("C:\Test.text",True)
Myfile.Writeline (Err.Number&Err.Description)
...
However I'm so wonder why did i get only the error code '0' and blank for error description?
Does anyone know how to catch up the error message?
Thnx in advance,
I've created a DTS package to transfer data. For each step of pakage I'd like to catch up the error message and write it into one file. I've tried to add one active script after each step (on failure).
I coded as below
...
Set Myfile = fso.CreateTextFile("C:\Test.text",True)
Myfile.Writeline (Err.Number&Err.Description)
...
However I'm so wonder why did i get only the error code '0' and blank for error description?
Does anyone know how to catch up the error message?
Thnx in advance,
