SQL Server Integration Services (SSIS): the successor to SQL Server 2000's Data Transformation Services (DTS)
the full product names for SQL Server’s BI products will be SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
BizTalk Server and SQL Server Integration Services perform different yet very complimentary functions
BizTalk Server is the key product for:
- Automating Business process that tie in applications, systems, employees, disparate technology and trading partners (BPM)
- Enterprise Application Integration (EAI)
- Business to Business Integration (B2B)
SSIS is the key product for:
- Moving Information into the SQL Server environment
- Complex transformation of data for loading into a persistent data store
- N source to N destination database loading
- Integration of data with other SQL Server products