I used ODBC as OLEDB providers still have some issues.

I got the same error. I used SQL Command from the dropdown in SSIS instead of Table or Views and then used Select * from Table_XX (or with where clause)....