Hello,
I have a very simple SSIS package which extract data from SQL Server into an Oracle database
I set the Batch Size of the Oracle destination at 50.
When I load 1 row the package fails:
[ADO NET Destination [2]] Error: An exception has occurred during data insertion, the message returned from the provider is: object reference not set to an instance of an object
When I load 2 or more rows the package succeeds.
When I load 1 row, with the batch size set to 0, the package succeeds.
Is there an issue about loading 1 row with ODP.NET ?
I use SSDT 14.0.61707.300 (build with Target set to SqlServer 2014) and ODP.NET 12.2.0.1.0
Thank you