Hi,
I have a method of a Com component. The method gets the xml string and parses it and populates a table in a database.
I wanted to call this method as one of the steps of a job. I am trying to use activex script to call that method. The step is running with out populating the table. Can any one help me, here is the code I am using in a job step,

function myfunction()

dim cn
dim rs
dim strSql
cn="connection string"
set obj=server.createobject("myCom.myClass&#34
set rs=obj.myMethod

myfunction=DTSTransformStat_OK

set rs=nothing
set obj=nothing

end function


Thanks in Advace,
Ravi Katakam.