What is an SSIS package and what does it do?

Question

Can someone tell me what an SSIS package is?

I am completely new to the data warehouse, and I am crazy for the terms SSIS, DTL, ETL and so on. I am looking for a big picture and how it fits into the overall architecture of .NET / SQL Server.

Answer 1

Update: grab a FREE copy of SSIS 2005 Step by step: http://csna01.libredigital.com/?urrs4gt63d

2nd Update: this link no longer works, but you can get the labs from MSDN here and get the book from Amazon

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

If you are an integration services specialist - http://msdn.microsoft.com/en-us/library/ms141667.aspx

If you are an administrator of integration services - http://msdn.microsoft.com/en-us/library/ms137815.aspx

If you are an Integration Services developer - http://msdn.microsoft.com/en-us/library/ms137709.aspx

If you are an archive of Integration Services - http://msdn.microsoft.com/en-us/library/ms142161.aspx

SSIS Overview - http://msdn.microsoft.com/en-us/library/ms141263.aspx

Practical sections of integration services - http://msdn.microsoft.com/en-us/library/ms141767.aspx

Answer 2

SSIS (SQL Server Integration Services) is a DTS (Data Transformation Services) update that is a feature of a previous version of SQL Server. SSIS packages can be created in BIDS (Business Intelligence Development Studio). They can be used to combine data from heterogeneous data sources in SQL Server. They can also be used to fill 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 for building data integration and workflow applications. The primary use for SSIS is a data warehouse, as the product has a fast and flexible tool for extracting, converting and loading data (ETL).). The tool can also be used to automate the maintenance of SQL Server databases, update multidimensional cube data, and perform other functions.

Answer 3

According to Microsoft, the main applications of the SSIS package are:

• Combining data from heterogeneous data storages populating data

• Warehouses and data cards Cleaning and standardization of data construction

• Business Intelligence to Automate Data Conversion Process

• Administrative functions and data loading

For developers:

SSIS can be integrated with the VS development environment to build Business Intelligence solutions. Business Intelligence Development Studio is a Visual Studio environment with enhancements specific to business intelligence solutions. It only works with a 32-bit development environment.

Download:

http://www.microsoft.com/en-us/download/details.aspx?id=36843