Hi, we were having the same problem in the tRedshiftOutput component, and found that when we unticked the 'extend insert' option under its advanced setting, and added a row -> main after the tRedshiftOutput to a tRedshiftCommit (untick the auto close connection), then the job ran without any issues.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Learn how and why companies are moving to the Cloud
Accelerate your data lake projects with an agile approach