That's the weird part. I have an ODBC sql tool that I can run queries in, and the query is running fine for that odbc connection. And I know it's connecting successfully because the query in the dataflow before it works just fine.
I'm wondering if I'm having some kind of issue with a null value somewhere. At first I thought maybe I was trying to insert something incorrectly into my sql db, but I'm not even getting to that point, this is happening in the first piece of the data flow, the datareader query to the progress db.