issue with stored procedure in DTS

[SqlHunter]

How can I call a stored procedure from vb script..because from DTS iam writing a script say 213433/tytty.xls.Now the first part is the emp_id and the second part is the desc and the third is the extension.Now using split function I could split them.Now I need to store them in table in emp_table of EM database .This Xls file is in a shared drive..I was able to get the split and all working but calling stored procedure to store the values in the table was giving problem..i was trying with
execute usp_emp_splitter @filename in vbscript of the DTS

 

[SqlHunter]

Is that possible to get output parameters after running DTS and use them in the stored procedure.Please somebody help me with this.