Sorry, I started with SQL 2008 R2 and BIDS in 2012. 3 years ago we migrated to SQL Server 2012 (and SSDT). So, I know none alternative but I think it's unnecessary.

Also in BIDS take a dataflow task. In the dataflow you are able to take sources, destinations and transformations. In the lookup transformation task you are able to select the dimension or to write a select statement also. I think it's all you need.

Before I started in SQL Server I used IBM InfoSphere - I'll never go back 🙂

May be it takes some time, to feel like home in BIDS 😉