Source and sink dynamics in meta-ecosystems