Sorry it's Sage ERP, i don't have any idea about the insert statement

Thank you,
I think that the easy way is creating an SSIS package, add a task script in loop container (Like this dump) .

            
June 2, 2018 at 6:41 pm
            
#1992748