What is SSIS package? What does it do?

Question

Can someone tell me what this SSIS package is all about?I am totally new to data-warehousing and I am going crazy with the terms SSIS,DTL,ETL and so on.I am looking for a big picture and how it fits in the overall .NET/SQL Server architecture.

Answer 1

As always Wikipedia offers a nice starting point.

Answer 2

**

Update: Grab a FREE copy of the SSIS 2005 Step-By-Step Here: http://csna01.libredigital.com/?urrs4gt63d

**

Getting Started with SSIS - http://msdn.microsoft.com/en-us/sqlserver/bb671393.aspx

If you are Integration Services Information Worker - http://msdn.microsoft.com/en-us/library/ms141667(SQL.90).aspx

If you are Integration Services Administrator - http://msdn.microsoft.com/en-us/library/ms137815(SQL.90).aspx

If you are Integration Services Developer - http://msdn.microsoft.com/en-us/library/ms137709(SQL.90).aspx

If you are Integration Services Architect - http://msdn.microsoft.com/en-us/library/ms142161(SQL.90).aspx

Overview of SSIS - http://msdn.microsoft.com/en-us/library/ms141263(SQL.90).aspx

Integration Services How-to Topics - http://msdn.microsoft.com/en-us/library/ms141767(SQL.90).aspx

Answer 3

SSIS (SQL Server Integration Services) is an upgrade of DTS (Data

Transformation Services), which is a feature of the previous version of

SQL Server. SSIS packages can be created in BIDS (Business Intelligence

Development Studio). These can be used to merge data from heterogeneous

data sources into SQL Server. They can also be used to populate data

warehouses, to clean and standardize data, and to automate

administrative tasks.

SQL Server Integration Services (SSIS) is a component of Microsoft SQL

Server 2005

It replaces Data Transformation Services, which has been a feature of

SQL Server since Version 7.0. Unlike DTS, which was included in all

versions, SSIS is only available in the "Standard" and "Enterprise"

editions. Integration Services provides a platform to build data integration and

workflow applications. The primary use for SSIS is data warehousing as the product features a fast and flexible tool for data extraction,

transformation, and loading (ETL). ). The tool may also be used to

automate maintenance of SQL Server databases, update multidimensional

cube data, and perform other functions