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

More
1 year 7 months ago #13897 by wilsjay
wilsjay created the topic: 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!!!

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

More
1 year 7 months ago #13898 by Moderator
Moderator replied the topic: Re: Import data from sql server to PG no records, no errors
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.131 seconds
Powered by Kunena Forum