Please check the following:
Ensure that the ODBC Settings are correct (Please follow steps in this article: Transaction Broker : How can I setup ODBC Link)
Test using another template
Ensure the status of the data to be uploaded within the template is set to 0
