p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server DTS (http://p2p.wrox.com/forumdisplay.php?f=108)
-   -   Accessing DTS scripting object in ActiveX script. (http://p2p.wrox.com/showthread.php?t=32747)

panakiom August 22nd, 2005 08:41 AM

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




All times are GMT -4. The time now is 06:09 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.