SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.
Technical & Business training in UK
I found this useful blog SQL Server DTS: Dynamically Change Source and Destination in Transform Data