SQL Server Integration Services: Difference between revisions

Content deleted Content added
Conscious (talk | contribs)
rm copyvio image
Line 5:
==Features==
 
Like DTS, SSIS features a [[Wizard (software)|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 appropriteappropriate 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. 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.