Brief Summary:
SSIS Stands for SQL Server Integration Services, a product delivered by Microsoft. SSIS basically is an ETL (Extract, Transform, Load) application. ETL signifies extracting data from different sources which can be an SQL data source, excel source, flat file source, xml source etc.., after data extraction comes performing some transformations on the extracted data which means applying business logic involved within any project.., and finally come loading the cleansed data into different destination which can again be an SQL Server destination, excel destination, flat file destination or xml destination.
License for SSIS:
No seperate license is required for SSIS which is an added advantage why SSIS can be preferred over any other ETL application, but ofcourse one should hold an licensed version of Microsoft SQL Server to avail the benefits of MSBI tools (SSIS, SSRS and SSAS) which comes along with Microsoft SQL Server
No comments:
Post a Comment