ETL: MySQL Identify field triggering Data truncated: Truncated incorrect... Errors

I often get Data truncated: Truncated incorrect... errors when setting up new ETL MySQL transforms.

Is there a way to identify the offending field?

Thanks in advance.

Comments

  • The first step would be to go into the Dataflow History tab, click on the run that failed and it shoud show you which step it's failing at.

     

    Once you know that, depending on what you're doing there, I would look and see what the current selected columns types are and play with converting them to full text until you find the offender. 

     

    Not a great way to pinpoint that other than some trial and error unfortunately.

     

    Would love to hear if someone else has a better method.

     

    Sincerely,

    Valiant

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.