I knew there'd be much missing in my description.

Getting it via email because it is a hosted Oracle Apps system and the people getting the file can't find any way to extract information other than sending something via email. We are going to pull Oracle in house at some point and the email part will stop. One reason this is a separate process.

System B I mentioned is a SQL Server database. There is some temp table/stored proc action going on there.

System C is Active Directory and we can make the connections in SSIS.

System D is Salesforce.com and we can use some other SSIS components.

Thanks