I created a console application that does some work and then the Function Main returns a -1 if an error occured or a 1 if the work completed successfully.

Step 2 is going to be creating a SQL Server DTS script to call this console app and send an email if the process did not complete successfully.

How can I return the 1 or -1 back to the DTS script? For some reason in my mind I had the notion to create a batch file that called this console app, and have the DTS script call that batch file, but I am pretty sure this would not be necessary.

Any advice out there in UT land?