What is Microsoft SQL Server Integration Services (SSIS)
Microsoft SSIS is a platform for building enterprise-level data integration and data transformation solutions. You can use integration services to solve complex business problems by copying or downloading files, sending emails in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data. Packages can be complex business needs alone or with other packages. Integration services can extract and transform data from a wide variety of sources, such as XML data files, flat files, and relational data sources, and then load the data into one or more target data carriers.
SSIS includes a rich set of built-in tasks and transitions; The tool is to build a package; and integrated service operation and management packages. You can use graphical integrated service tools to create solutions without writing a single line of code; Alternatively, you can broadly integrate the service object model to programmatically create custom tasks and other package objects for packages and code.
SSIS use cases
SSIS application is mainly in some business intelligence large-scale data systems, data extraction, cleaning, etc., to obtain high-quality data, is enterprise
Analyze accurate results when doing analysis. At the same time, SSIS will also be applied to daily data management, such as the management of databases by some DBAs.
Manage database jobs, migrate databases, merge and other tasks.
Database management
Sometimes you just need to transfer data. The import and export wizard can migrate data between Excel and SQL Server data tables, flat files, and ODBC connections. It allows data transfers to specify table replication or querying, giving DBAs the ability to scale to merge or transform data.
A good example is creating or refreshing a test database. Production data is often used to validate changes. The SQL Server Import and Export Wizard uses SSIS to move data from source to destination.
Business intelligence
The primary use of BI data integration tools is for extract, transform, and load (ETL) operations. SSIS is used to perform ETL. At the heart of SSIS is the Data Flow Task, which is figuratively described as a "pipeline structure", a powerful and flexible data pump.
|
Posted on 6/12/2020 1:21:30 PM
|
|
|
Landlord|
Posted on 6/12/2020 1:21:34 PM
|
