View Single Post
  #1 (permalink)  
Old August 22nd, 2005, 08:41 AM
panakiom panakiom is offline
Registered User
 
Join Date: Aug 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Accessing DTS scripting object in ActiveX script.

Hi
I want to access DTS scripting object (i.e DTSTransformPhaseInfo)
In my DTS ActiveX Script task, here is the code snippet...

dim fso
dim objStream

const OUTPUT_FILE = "c:\CSVstatus.txt"
set fso= CreateObject("Scripting.FileSystemObject")

set objStream = fso.OpenTextFile(OUTPUT_FILE, 2, true)

Function InsertSuccessMain()
objStream.WriteLine("Status : " &
DTSTransformPhaseInfo.CurrentSourceRow)
     InsertSuccessMain = DTSTransformstat_OK
End Function
Here I am getting
Object required: 'DTSTransformPhaseInfo'
Error message while executing the DTS package. As I am not much aware of this DTS framework. Please give me some idea how to access these DTS scripting object in ActiveX script.

Thanks in advance
- Pankiom