SQL Server Integration Services (SSIS) is an important service that is required to continue the ETL (extract transform load) tasks on your data platform. You may notice that since SQL Server 2005 version onwards the database maintenance plans will always use SSIS packages to perform the key maintenance activities. Though SSIS service is not imporant here but it is ideal to continue the key ETL activities using SSIS packages than TSQL methods. Just going back to basics running SSIS provides many capabilities...(
read more)
No comments yet, be the first one to post comment.