MSFT SSIS

From Glitchdata
(Redirected from SSIS)
Jump to navigation Jump to search
ACTIVE TECHNOLOGY
  • Status: Active
  • Category: ETL
  • Platform: Windows
  • Maturity: High
  • Licensing: Yes

SQL Server Information Service (SSIS) operates on data integration and dataflow. Previously called Data Transformation Services (DTS in SQL Server 2005). Microsoft has packed SSIS as 2 key components:

  1. SQL Server Data Tools
    • This take parts of Visual Studio and DTS, and integrates it into a single product.
  2. SQL Server
    • Where SSIS packages are deployed to
    • Integration Services Catalog list the available packages.

SSIS is used manipulate files or data. Example:

  1. Move and rename files
  2. Delete, update or insert data
  3. Execute SQL scripts or stored procedures
  4. Import and export data between different file types, such as Access, Excel, ODBC-connected data sources.


Usage

Versions

  • SQL Server 2005
  • SQL Server 2008
  • SQL Server 2008 R2
  • SQL Server 2012

Links

Related Technologies