SQL Server Integration Services: Difference between revisions

Revision as of 01:10, 18 February 2006

Revision as of 01:17, 18 February 2006

Line 7:

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 approprite 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 userspackages utilize a visual designerdevelopment hostedtool insimilar theto '''Microsoft Visual Studio shell. This designer is''' called the SQL Server Business Intelligence Studio. It allows users to edit '''SSIS packages''' using by 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 workworkflow for the package. doesUpon whenpackage execution, the tool provides color-coded, real-time executedmonitoring.

'''Connections'''. A connection includes the information necessary to connect to a particular data source. Tasks can reference the connection by its name, allowing the details of the connection to be changed or configured at runtime.