This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
@nhunter I haven't run into this with SQL server specifically, but I have seen it in other DB's. In my experience, yes it could be anything.
Generally you can clear up/start narrowing down a few different ways:
1. Add an Auto-Field tool right before your output tool. See what it changes and if that still throws the same errors.
2. If that doesn't help get you to the right answer, add a Dynamic Select (or Select) right before the Output and only insert fields of the same type and size each run (to temp tables or something you can dump). Keep doing this until you hit the error and then you can get more info about what's causing it.