Are there any transactions on that particular day?
Check the data "by eye" and see if it's the query that's "missing" them or if they really aren't there at all!
Your query looks OK to me.
Your table I'm less convinced about.
Having a table called "table" is a Bad Idea.
Using any reserved word as an identifier (table, column, ...
We where able to solve the Connection Problems with the Package Parameter Tab. Here you are able to "Save" for each connection the Username and Password (In clear Text ^^?!). And then the Package can connect.