Import data from sql server to PG no records, no errors

Trying to move data from sql server to PG via SSIS package created for the sql server Import Export wizard using OLE DB destination (not a linked server). I have a few tables where no records will be imported into PG. I am seeing no errors in SSIS and information messages will say "Data Flow Task 1, SSIS.Pipeline: "component "Destination - MyTableName" (52)" wrote 1367518 rows." in the SSIS logs, but when I query the table in PG (select count(*) from MyTableName;) it still has zero rows. PLEASE HELP!!!

The rows maybe not visible outside a transaction. Please make sure that package execution is completed, and then check the result. This is the only scenario I can imagine at this moment.