databasejournal.com databasejournal.com

Flat File Imports with SQL Server Integration Services 2008

Introduction 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...

databasejournal.com databasejournal.com

Introduction to SQL Server 2005 Express Edition Reporting Services Content Management

In the recent installments of our series dedicated to the most prominent features available in SQL Server 2005 Express Edition, we have been discussing Reporting Services. So far, besides presenting an overview of its basic characteristics and stepping through its installation, we have also covered the process of creating reports, employing functionality built-into the Report Designer and leveraging sample reports published by...