SSIS

  Difference between DTS and SSIS DTS: 1.DTS stands for Data Transformation Services 2.DTS is a set of objects using an ETS tool to extract, transform, and load information to or from a database 3.DTS was originally part of the Microsoft SQL Server 2000 4.Uses Activex Script 5.No Deployment wizard is available 6.Limited Set of Transformation available 7.Does not support BI Functionality 8.Single Task at a time 9.It is Unmanaged script 10.DTS can develop through Enterprise manager 11.We can deploy only at local server 12.Designer contains Single Pane 13.No Event Hander 14.No Solution Explorer 15.Connection and other values are static, not controlled at runtime. SSIS: 1.SSIS stands for Sql Server Integration Services 2.SSIS is an ETL tool provided by Microsoft to extra data from different sources. 3.SSIS is a component of the Microsoft SQL Server 2005 4.Uses Scripting Language 5.Deployment wizard is available 6.Huge of Transformations available 7.Completely supports end to end proces...

  SSIS stands for  SQL Server Integration Services . It is a part of the Microsoft SQL server and is a well-known integrated platform for performing enterprise-level data migration and transformation activities. The platform is used for solving complex problems like reading, loading, copying, or downloading large files, mining data, extracting relevant information, and managing SQL objects. It supports data sources like relational databases, XML, flat files, etc, and helps to load and send data to multiple destinations. It performs three important tasks "Extraction", "Transformation" and "Loading". It is an enterprise tool for data integration, data transformation and data migration.

  Why MSBI (Microsoft BI):    MSBI stands for Microsoft Business Intelligence. This powerful suite is composed of tools, which help in providing best solutions for Business Intelligence and Data Mining Queries. This tool uses Visual studio (BIDS) along with SQL server. It empowers users to gain access to accurate and up-to-date information for better decision making in an organization. It offers different tools for different processes, which are required in Business Intelligence (BI) solutions. SQL Server makes business intelligence available to everyone through deep integration with Microsoft Office, providing the right tool, to the right user, at the right price. Employees at all levels of an organization can see and help to influence the performance of the business by working with tools that are both easy to use and powerful. Microsoft SQL Server includes several features that make it easy and inexpensive to implement business intelligence (BI) and data warehousing. Th...