What is SSIS?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is SSIS?
Rating:
SSIS (SQL Server Integration Services) is an upgrade of DTS (Data Transformation Services), which is a feature of the previous version of SQL Server. SSIS packages can be created in BIDS (Business Intelligence Development Studio). These can be used to merge data from heterogeneous data sources into SQL Server. They can also be used to populate data warehouses, to clean and standardize data, and to automate administrative tasks.
Rating:
Was this information helpful?
Other articles
- What are trace flags?
- What is the db_dtsadmin fixed database role?
- What counters are used to measure network traffic?
- What is SSRS?
- What is the dbcreator fixed server role?