Jump to content

SQL Server Integration Services

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by 122.169.3.137 (talk) at 10:24, 26 October 2013 (→Extensibility and programability). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks.

SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data.

First released with Microsoft SQL Server 2005, SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0. Unlike DTS, which was included in all versions, SSIS is only available in the "Standard" and "Enterprise" editions.

TEST 234

Other included tools

Aside from the Import/Export Wizard and the designer, the product includes a few other notable tools.

DTEXEC executes a package from the command line wherever it may be stored.[1][2] Before running the package, the tool may be instructed to apply configuration information, which will allow the same package to be reused with slightly different parameters, including different connection strings for its endpoints.

DTUTIL provides the ability to manage packages from the command prompt.[3][4] The tool can copy or move a package from a file into the server store, or back out again. Among a few other sundry functions,it can be used to delete, rename, encrypt, or decrypt packages.

SADF

See also

References

  1. ^ "dtexec Utility (SSIS Tool)". Microsoft Developer Network. Microsoft. Retrieved 2013-03-24.
  2. ^ Marcin Policht (2010-08-09). "Executing SSIS Packages Using DTExec". Database Journal. Retrieved 2013-03-24.
  3. ^ "dtutil Utility (SSIS Tool)". Microsoft Developer Network. Microsoft. Retrieved 2013-03-24.
  4. ^ Yan Pan (2008-03-20). "Using dtutil to copy SSIS packages stored in SQL Server". Database Journal. Retrieved 2013-03-24.
Retrieved from "https://en.wikipedia.org/w/index.php?title=SQL_Server_Integration_Services&oldid=578804778"