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

More
1 year 5 months ago #13897 by wilsjay
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!!!

Please Log in or Create an account to join the conversation.

More
1 year 5 months ago #13898 by Moderator
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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.126 seconds
Powered by Kunena Forum