simple DTS question

Amorous · January 13th, 2006, 03:30 PM

i have two connections...

source - Access Database
destination - Sql server

i have this test activex script

Code:

Function Main()
set pkg=DTSGlovalVariables.parent
set otask=pkg.Tasks(1)
msg("set object name :"&otask.SourceObjectName)
End Function

i am getting error...object doesnot support this method

any suggestions...

David_the_DBA · January 14th, 2006, 10:50 AM

That is because The task object has no such property or method. You want Name or Description.

Try using the object browser in the MS Office Macro VB Editor or in VS6 to look at the various members available on the objects. Additionally the object model is documented in the online docs:
http://msdn.microsoft.com/library/de...papps_0jsd.asp
http://msdn.microsoft.com/library/de...thobj_9nhw.asp

Additionally, I am nost certain what you are trying to accomplish by calling the function called msg? There is no such function defined in VBScript. There is a MsgBox, but you only use that for Debugging a DTS package, since it halts the execution of the package.

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

Amorous · January 16th, 2006, 12:04 PM

Thank you so much for your reply...i really appreciate it and will try to work on your suggestion.