(Object required) DTSPackageLog

I get "(Object Required)" when trying to

"DTSPackageLog.WriteStringToLog sErrorMessage" in transformation vbscripts being used by DTS.

All available documentation indicates that this should not be possible as it is 'intrinsic' like "DTSGLobalVariables".

What's the secret?I too have been trying to make this work. I found a script on SQLDTS.com that I've cut and pasted and whenever I try to run it, I am faced with the Object Required: 'DTSPackageLog' error.

http://www.sqldts.com/default.aspx?6,101,238,0,1

Any suggestions would be helpful!

Thanks,

Bob

Originally posted by Hollerith
I get "(Object Required)" when trying to

"DTSPackageLog.WriteStringToLog sErrorMessage" in transformation vbscripts being used by DTS.

All available documentation indicates that this should not be possible as it is 'intrinsic' like "DTSGLobalVariables".

What's the secret?