OLE DB Source in SSIS is returning only the first 100 rows of the table.

More
6 months 2 weeks ago #14473 by Jose Sebastian
Jose Sebastian created the topic: OLE DB Source in SSIS is returning only the first 100 rows of the table.
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 ?

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

More
3 months 2 weeks ago #14491 by admin
admin replied the topic: OLE DB Source in SSIS is returning only the first 100 rows of the table.
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.).

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

Time to create page: 0.113 seconds
Powered by Kunena Forum