I'm in need of batching a mySQL query. I'm wanting to do this by dynamically setting the mySQL Source Query as such:
Code: Select all
SELECT AccountNumber,SupplierInvoiceNumber
FROM tblInvoice
GROUP BY AccountNumber,SupplierInvoiceNumber
ORDER BY AccountNumber,SupplierInvoiceNumber
LIMIT '<@User::recordsAffected>','<@User::batchSize>'
regardless of the batch and skip sizes I put in."near limit 0,100"
Anyone help?