I am working on a VB 6 interface that works with a SQL 2000 back end to perform a data import from a legacy system. I am using VB DTS files and SQL 2000 Stored Procedures to process each incoming table. The interface has a type of progress indicator for the user that uses total number of records and number of records imported to display the progress bar.

I know that stored procedures can return values to calling stored procedures [return(integer)] but, is there any way VB can get an integer back from a stored procedure so that I can update the progress bar?

VB Calling Code:

QueryString = "EXECUTE " & strImportSp 
cnImport.Execute(QueryString)

Thank for your help
Rhonda