SQL Server 2008 includes a powerful data integration and
transformation application called SQL Server Integration Service (SSIS). One
of the main functions of SSIS is to move data into and out of SQL Server. The
external data source can exist in almost any format, another database, Excel
sheet, XML file, or a plain text file to name just a few. Not only can data be
moved from source to destination, but it can be...