When using PGNP OLEDB Providers for PostgreSQL, in SSIS, OLE DB Source is returning only the first 100 rows of the table.
I tried Data Access mode with Table or View Option only first 100 rows are returned
Then tried SQL Command option with Select * from TableName. Still only first 100 rows are returned.
Any setting required to get all rows ?
Hi! This is limitation of the Trial version. If you install commercial module it will handle any number of rows (of course, limitations can come from memory, CPU, network, etc.).
