Sunday 26 May 2013

SSIS First simple Project

Microsoft SQL Server 2008 Integration Services (SSIS) is a platform for building high performance data integration solutions, including the extraction, transformation, and loading (ETL) of packages for data warehousing. SSIS is the new name assigned to the component formerly branded as Data Transformation Services (DTS).

SSIS (SQL Server Integration Services) is an upgrade of DTS (DataTransformation Services), which is a feature of the previous version ofSQL Server. SSIS packages can be created in BIDS (Business IntelligenceDevelopment Studio). These can be used to merge data from heterogeneousdata sources into SQL Server. They can also be used to populate datawarehouses, to clean and standardize data, and to automateadministrative tasks.















No comments:

Post a Comment