Some information on SAP Data Services here, and a refresher on Databases and Data Warehousing.
Also, an interesting post on ETL vs ELT. Would it be faster to use ETL to transform your data before loading, or would it be faster to just copy your data directly to the warehouse and manage it inside?
Perhaps this is the role the new FileTable type in SQL 2012 will play for you. Why not FTP your CSV files directly into SQL as blobs, and manage the transformations within?
Maybe not the best example, but it does centralize things a bit more…