SSIS or Sql Server Integration Services can used in current requirements, to perform opertions like Extraction Transformation Load (ETL). If there is requirement to produce flat files, excel files, Comma Separated Files or any other types of requirements like movement of data into database or from database.
SSIS code is saved in .dtsx extension and requires DTExec runtime to execute. Dtexec in turn requires .net framework.
Inorder to Start with SSIS, you need to have Business Intelligence Studio which comes with SQL server and during installation please check install BI option during installation.
SSIS package has two main components 1) Control Flow 2) Data Flow component.