In my select list I replaced all columns by max(len(<your_column_name> ) ) as <your_column_name>
So, it returns one row with all the max lengths.
Then you can look at your...

Thank you for the reply. Do you have any notes on how to install on the machine where the Agent service runs? I assume that is the SQL Server machine...

Did you get an answer this as I have hit the same problem today? On SQL Server 2012 - I created a SSIS package using an oData connection to SharePoint...