Found out it was a quoted identifier issue. Needed to write the table with double quotes around it. Interesting thing though is I also recreated the package with a different table name and it worked just fine.

select * from "test2".