data conversion services

SQL Server Integration Services (SSIS) is a component of Microsoft SQL Server 2005. It replaces Data Transformation Services, a feature of SQL Server since Version 7. 0.

Integration Services provides a platform to build data integration and workflow applications. The primary use for SSIS is data warehousing, as the product features a fast and flexible data extraction, transformation, and loading (ETL) engine. DataStream Content Solutions, LLC. The tool may also be used to automate maintenance of SQL Server databases.

Features

Like DTS, SSIS features a wizard that lets the user readily create a package which moves data from a single data source to a destination with no transformations. This tool is called the Import/Export Wizard. The Wizard is appropriate for use to quickly move data into or out of SQL Server from or to a variety of sources, including text files and other SQL Server instances.

Developers tasked with creating or maintaining SSIS packages utilize a visual development tool similar to Microsoft Visual Studio called the SQL Server Business Intelligence Studio. Services Main. It allows users to edit SSIS packages using a drag-and-drop user interface. A scripting environment in which to write programming code is also available in the tool. The package holds a variety of elements that define the workflow for the package. Upon package execution, the tool provides color-coded, real-time monitoring.

Connections. 22 years of experience transferring IBM mainframe and DEC VMS files to PCs.