Integration services is an ETL tool for transferring data from a data source to a taget. It can be used for populating databases and data-warehouses.
There are a lot of data modifications that you can use SSIS for to transform the data while you load it.
do you have any specific questions?