• Try using this in part of your script, I don't think you can have a colon (: ) in the file name, that might be the reason it's not working, this should remove the : from the name:

    LEFT(REPLACE(REPLACE(CONVERT(VARCHAR,GETDATE(), 120), ' ', '_'), ':', ''), 18)