1. Forum
  3. Main PGNP Forum
  5. SQL Server/DTS/SSIS/Linked servers/Replication
  7. Import data from sql server to PG no records, no errors

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

  • wilsjay
  • Topic Author
  • Visitor
  • Visitor
5 years 11 months ago #13897 by wilsjay
Import data from sql server to PG no records, no errors was created 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
5 years 11 months ago #13898 by Moderator
Replied by Moderator on 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.

  1. Forum
  3. Main PGNP Forum
  5. SQL Server/DTS/SSIS/Linked servers/Replication
  7. Import data from sql server to PG no records, no errors
Time to create page: 0.073 seconds
Powered by Kunena Forum