Loading huge volume of data into Target Systems

Hi,

I want to load a huge amount of data from Snowflake to SQL server and I want to load it in batches, so that it will not fail because of any SnapLogic memory issue or resource issue. Also I don’t want to use script snap.
Does any one has such kind of sample pipeline?

@dmiller @skatpally

Thanks