what is ssis package

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that is used to perform data migration tasks at scale. An SSIS package is an organized collection of connections, control flow elements, data flow elements, event handlers, variables, parameters, and configurations that are assembled using either graphical design tools or built programmatically. The package is the unit of work that is retrieved, executed, and saved. SSIS packages can be used to merge data from various data stores, automate administrative functions and data loading, populate data marts and data warehouses, clean and standardize data, and build business intelligence into a data transformation process. SSIS includes two graphical tools, SSIS Designer and SQL Server Import and Export Wizard, in addition to the SSIS object model for creating packages.