SQL Server Integration Services (SSIS)

Posted: Oct/07/2009 By: pankaj Points:15 Category: SQL Server - Query Views:153 Vote Up (0) Vote Down (0)

SQL Server Integration Services (SSIS) allows you to integrate smoothly with other applications and data sources.

You can use Integration Services to copy or download files, send e-mail messages in response to events, update data warehouses, clean and mine data, and manage SQL Server objects and data.

In SQL Server 2005 and higher, Data Transformation Services (DTS) is no longer installed with SQL Server. All DTS related tasks are now performed with SSIS.

View Complete Post

Comments:

Be the first to comment this post.

Post Comment

Please login to post your comment

More Related Resources

SQL Server - Views Tutorial

In SQL Server, a view is a pre-written query that is stored on the database. A view consists of a SELECT statement, and when you run the view, you see the results of it like you would when opening a table. Some people like to think of a view as a virtual table. This is because a view can pull together data from multiple tables, as well as aggregate data, and present it as though it is a single table.

SQL Server - SQL Scripts Tutorial

In the previous lesson, we added data to our database table using the "Edit Top 200 Rows" option. In this lesson, we will look at how to write SQL scripts to update and run queries against our database.

Create a New Query
Before we generate our SQL script, we need somewhere to enter it into. This part is easy. Just click the "New Query" button: