*
The SSIS Import/Export Wizard lets the user create packages that move data from
a single data source to a destination with no transformations.
*
The Wizard can quickly move data from a variety of source types to a variety of
destination types, including text files and other SQL Server instances.
*
Developers tasked with creating or maintaining SSIS packages use a visual
development tool based on Microsoft
Visual Studio called the SQL Server Business Intelligence Development Studio
(BIDS).
* 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. A package holds a variety of
elements that define a workflow. Upon package execution, the tool provides
color-coded, real-time monitoring.
No comments:
Post a Comment