I have same issue. So could you help to find out the solution? Thanks so much.
In the script, I will need you to add an attribute to the DataConnector operator definition, as:
VARCHAR TraceLevel = 'all'
and re-run the job that fails and send me the .out file for that job (can be found in the "logs" subdirectory which is located in the TPT install directory).