Thanks, I'll do my best to figure this out from here.

I want to bulk insert file 1 if file 2 does not contain data. I want to bulk insert file 2 if file 1 contains no data. The...

That checks to see if the file itself exists, I need to check to see if there is actual data in the file.

Thanks for your quick response.

The stored procedure runs everyday at 6:30 AM, I thought alerts were for specific error messages. I would not necessarily know the error message from the script. Can...

Thanks everyone!

That's it, thanks! I knew it was something easy, long weekend, Monday came too quick. Thanks for your help!

Thanks!  I'll use this one. 

The first code worked perfect.  Thank you very much for your assistance!

Great instructions, I'll give it a try.  Thanks!

Thanks for the help so far, does anyone have an example of any of the above posts?