Not quite sure on this one. I need to figure out a way to catch an error that is thrown from a DTS that is being ran by calling a stored procedure in .NET. The Stored procedure contains the execute DTS info.

When I run the function that calls the procedure it seems to work and move onto the next page, but when the database is checked no information has changed due to an error in the DTS. I need to know how to catch that error and handle it so that the user of the app knows there was an error.

Current Process Flow.

Click Upload button ----> function called to use stored procedure ----> Stored Procedure executes DTS ----> DTS fails or completes depending on information -----> Page moves onto Confirmation screen.

Unfortunately it always moves to the confirmation screen whether the DTS fails or not.

Thanks in advance for the help.