How to create a Dynamic pipeline

Hi,

I have a requirement to extract data through multiple azure tables from SQL server & dump into multiple tables in azure tables. I wanted to create a generic pipeline. Can anyone suggest how to create it?

Thanks