How can I use SSIS to copy data from 1000 tables i

问题:

I think I can use a for each container for doing this. There are multiple examples for SQL servers but not for other types. Can anyone suggest me how to do this in SSIS? (CRM doesn't have SQL database).