I am working on an 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.

So...... is there any way to get an integer back from a stored procedure so that I can update the progress bar?


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