Insertion in blocks of 900 lines

[Anonymous]

Hello

Does anyone know how I can perform a load limiting the insertions in 900 rows?

I need to load about 50 thousand lines, but in blocks of 900

the destination is an Azure DW.

Thank you in advance.

[Anonymous]

Hello,

There is a "commit every" option in Advanced settings of tSQLDWHOutput component .

You can enter the number of rows to be completed before committing batches of rows together into the database. This option ensures transaction quality (but not rollback) and above all better performance on executions.

Let us know if it is what you are looking for.

Best regards

Sabrina