Microsoft SSIS Integration
SQL Server Integration Services is part of the Business Intelligence Development Studio (BIDS) and is a platform for building enterprise-level data integration and data transformations solutions. Scaled deployment across the target servers allow for easier maintenance of the packages and reports.
Capabilities
Chateaux employs this technology to solve complex business problems. SSIS can be used to copy or download files, send e-mail messages in response to events, update data warehouses, clean and mine data, and manage SQL Server objects. The Microsoft SSIS package includes:
- ETL tool used for data warehousing, administration, and migration of data with the ability to extract data from a wide variety of sources such as XML data files, flat files, and relational data sources
- Import/Export Wizard used to quickly move data from a variety of sources to a variety of destinations
- Ability to design packages that could help in performing automation of the environment
- Ability to serve a wide range of the development and administration groups with packages including customized objects and scripts
|
|
