SQL Server Integration Services (SSIS) is Microsoft's replacement for SQL Server
Data Transformation Services (DTS). It is server-based solution which ships with
Microsoft SQL Server. One benefit of SSRS is that many companies who utilize SQL
Server already have it in house. Another benefit is that it is tightly
integrated with SQL Server and shares many of the same tools. SSIS allows users
to create workflows which massage, manipulate, enhance and transform thier data.
It can be used to load or share data amongst different databases as well as
extract data for various uses.
Jetstream has sucessfully delivered numerous database products which leverage
SSIS - either to facilitate the creation of custom or enhanced datasets or to
routinely import data from various data sources into production systems. For
several of our customers this data is thier product offering and ensuring
accuracy and integrity of data is vital to thier business.