The log pointed to an error in the connection.
It's not very obvious as to how to set up the connection, but for anyone whom this may help.
I used a report that didn't have parameters.
To set up a crystal report export task, you have to specify a connection as a Crystal Report protocol, to the sql server to which the report connects.
Also specify the credentials the report uses to connect to the sql server in the Authentication tab.