You use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.
I like to use it to download bank and credit card transactions and importing the data into the database for coding.