Microsoft SQL Server Integration Services is a platform for building high performance Data Integration modules. It includes Extraction of data from several sources, Transformation of data and Loading of data. SSIS provides a way to build packages made up of tasks to migrate data from one source to another destination. Bussiness Intelligence Development Studio IDE will help in developing packages.
Simply SSIS is automation to SQL Server operations. "The difference between SQL Server and SSIS is that SQL Server stores data(database) where as SSIS just migrates data from source to destination. SSIS tool does not store any kind of data".
Simply SSIS is automation to SQL Server operations. "The difference between SQL Server and SSIS is that SQL Server stores data(database) where as SSIS just migrates data from source to destination. SSIS tool does not store any kind of data".
No comments:
Post a Comment