Server 2005 Integration Services (SSIS) introduces a rich toolset that supports the development, deployment, and administration of the extract, transform load (ETL) solutions. The Integration Services tools for developing and configuring packages, the tools that are available in Business intelligence Development studio.
1) In Business Intelligence Developments Studio, you develop your business solutions in the context of a solution and a project. A solution is a container that manages multiple projects as one unit. Typically, the projects in a solution are related, and together they support a business solution. A solution can include different types of projects such as Integration Services Analysis Services, or Reporting service projects.
I am listing two videos for you might help you to learn and get more insight on how SSIS and SSRS works:
2) Functional Details
SQL Server Integration Service (SSIS) is a component of the Microsoft SQL Server database software that can be used to execute a wide range of data migration tasks. SSIS is a fast & flexible data warehousing tool used for data extraction, loading and transformation like cleaning, aggregating, merging data, etc.
It makes it easy to move data from one database to another database. SSIS can extract data from a wide variety of sources like SQL Server databases, Excel files, Oracle and DB2 databases, etc.
I would even suggest you to go through the blog here https://www.edureka.co/blog/ssis-tutorial/
3) Technical Details
In SSIS tool, you can add a task to control flow. There are different types of tasks which perform various kinds of works.
Some important SSIS tasks are mentioned below:
- Execute SQL Task:- As its name suggests, it will execute a SQL statement against a relational database.
- Execute Package Task:- Use can use this SSIS task to execute other packages from within the same project.
- FTP Tasks:- It allows you to perform basic FTP functionalities.
4) Code walkthrough
I guess for a good hands-on you must visit here: https://www.youtube.com/watch?v=0ikNnenDyNw&t=26s and https://www.edureka.co/blog/sql-server-management-studio/
The Execute Process task can be used to run an application or a batch file as one of the steps in an SSIS package. The input, output and arguments of the application can be set in the editor of the task and be used at run-time.
I hope the information will be helpful for you!!!