It does sound like a permission error. Check that the account running SQL Agent has access to the folders where the Excel template file is stored (and where the new...

I was having the same problem and found that you need to check like this *before* you try to do something to the column:

If Not Row.Column_IsNull Then

'Do...