SQL Server 2008 Integration Services

SQL Server Integration Services (SSIS) is a tool that allows to perform operations on the data type ETL (E - extraction, T - transformation, L - loading). This activity is typical in data warehousing systems (systems designed to allow you to easily produce reports and analysis on the data) but is useful in many other contexts.

High level SSIS lets do the following:

• extract data from different sources
• perform various transformations on the data
• load the data into different systems
• define workflows

The first version was released with the SSIS SQL Server 2005 with the aim of replacing the instrument Data Transformation Services (DTS), available in previous versions of Microsoft's DBMS.

In particular, the SQL Server Management Studio provides import and export procedures that can be used to transfer data from one source to another easily and quickly. It 'can choose between various types of data sources, copy data from a table (or using a specific query) and save all these operations in the so-called SSIS package.

But we see in more detail the steps to take and in particular suppose we want to transfer data from a SQL Server database to a spreadsheet.

We start the SQL Server Management Studio Object Explorer window and click with the right mouse button on the database from which we get the data (in our case AdventureWorksDW), choosing the context menu that opens the voice Tasks and then Export Data

This starts a wizard through which you must first select the data source (in the case of our example the AdventureWorksDW database, housed on the server myserver) Further we set as the destination of the data path of an Excel spreadsheet that we created earlier, called Test.xls On the next screen choose the option Copy data from one or more tables or views that will allow us to select the source table (instead of choosing the other option we should hand write the query from the database through which to extrapolate data to import)

• <<
• 1
• 2
• 3
• 4
• >>