Just had a stab in the dark and tested all the following:
SELECT CONVERT(varbinary(MAX),CONVERT(datetime2(0), '20170809 16:19:53.830')),
       CONVERT(varbinary(MAX),CONVERT(datetime2(5), '20170809 16:19:53.830')),
       CONVERT(varbinary(MAX),CONVERT(datetime, '20170809 16:19:53.830')),
    ...

how was the varbinary value created? Are you sure that the original value was a datetime2? For example, if it was originally a datetime, using CONVERT(datetime2(x)) isn't going to work....

Thought I might as well post a little on TRY CATCH and Transactions with a little example. The actual process here, in the sense of the transaction, is a little...

At a quick glance, the email in the first SP is only sent if the CATCH is entered. If there are no errors in your TRY, the transaction is committed...

You should already know this, but can you please post proper sample data and DDL (see the link in my signature), and the expected output. The floats are really malformed...

I can't think of anything myself, but this sounds more of a training thing that anything. Users should be checking their connection information before running a statement (especially if making...

Yeah, see you're point. I focused on the statements:

The Excel file contains multiple tabs with each month of data in it. I should treat the current month tab like...

Don't you just love it, when you hand a process over to someone else, so that you can spend more time getting the "important" things done? Just you just love...