DTS vs SSIS - Data Transformation Services vs SQL Server Integration Services

By: Jimit Shah | Views: 2163 | Date: 19-Jul-2011

Here we have provided some differences between DTS and SSIS. It may be useful to answer interview question related to SSIS (MSBI)

Here we have provided some differences between DTS and SSIS. It may be useful to answer interview question related to SSIS.

Data Transformation Services (DTS) provides a set of tools that lets you extract, transform, and consolidate data from disparate sources into single or multiple destinations.

SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data.

Below are some differences between SSIS and DTS:

S.noDTSSSIS
1Data Transformation ServicesSql Server Integration Services
2Using Activex ScriptUsing Scripting Language
3No Deployment wizardDeployment wizard
4Limited Set of Transformation availableHuge of Transformations available
5Not Supporting BI FunctionalityCompletely supporting end to end process of BI
6Single Tasks at a timeMulti Tasks run parallel
7It is Un managed scriptManaged by CLR
8DTS can develop thru Enterprise manageSSIS can thru Business Intelligence Development Studio (BIDS, nothing but new version of VS IDE)
9We can deploy only at local serverIt can be deployed using multiple server using BIDS
10Designer contains Single PaneSSIS designer contains 4 design panes:


  a) Control Flow


  b) Data Flow


  c) Event Handlers &


  d) Package Explorer.
11No Event HanderEvent Handler Available
12No Solution ExplorerSolution Explorer is available, with packages, connections and Data Source Views (DSV)
13Connection and other values are static, not controlled at runtime.It can be controlled dynamically using configuration

Previous Page Next Page

People Searching On This Page:
  • ssis vs programmierung
  • data transformation services sql
  • email wizard.com.br loc:IN
  • ssis interview questions
  • data transformation services
  • DTS designer interview questions
  • DTS and SSIS similarities
  • data transformation services interview questions
  • ssis vs dts
  • dts vs ssis
  • SQL Server DTS SSRS

Related Pages


BlackBerry Z10 vs Apple iPhone 5 vs Nokia Lumia 920 vs LG Google Nexus 4 vs Samsung Galaxy S III

BlackBerry Z10 vs Apple iPhone 5 vs Nokia Lumia 920 vs LG Google Nexus 4 vs Samsung Galaxy S III

Articles | Technology | Smart Phones
Date:
31-Jan-2013  Views: 1885

Here we have listed comparison between BlackBerry Z10 vs Apple iPhone 5 vs Nokia Lumia 920 vs LG Google Nexus 4 vs Samsung Galaxy S III. ...
Apple iPhone 5 vs. Samsung Galaxy S III vs. Nokia Lumia 920 vs. Droid RAZR HD

Apple iPhone 5 vs. Samsung Galaxy S III vs. Nokia Lumia 920 vs. Droid RAZR HD

Articles | Technology | Smart Phones
Date:
12-Sep-2012  Views: 2778

The iPhone 5 launches into a more challenging field of competitors than ever, and to give you some context about the iPhone 5 specifications compared ...
Google Nexus 7 vs iPad 3 vs Kindle Fire vs Microsoft Surface

Google Nexus 7 vs iPad 3 vs Kindle Fire vs Microsoft Surface

Articles | Technology
Date:
30-Jun-2012  Views: 2185

Which tablet reigns supreme? Here is the comparison between Google Nexus 7 vs iPad 3 vs Kindle Fire vs Microsoft Surface ...
SSRS Interview Questions - SQL Server Reporting Services

SSRS Interview Questions - SQL Server Reporting Services

Articles | Programming | MS SQL
Date:
20-Aug-2011  Views: 1789

Here we have provided some interview question regarding SQL Server Reporting Services (SSRS) Technology. All the Best. ...
rashad vs rampage results - get all rashad vs rampage results now

rashad vs rampage results - get all rashad vs rampage results now

Articles | Sports & Fitness | Muscle Building
Date:
30-May-2010  Views: 1668

Well the internet is a awesome place and the internet means only one thing to many people free stuff. So do you want to watch Rashad vs rampage result ...
Post Your Comments (No Login Require)
Name : (required)
Email : (required)
Website :

Comment : (required)

87  + 8 =     
Comments
People Searched About:
Ssis Vs Programmierung   |   Data Transformation Services Sql   |   Email Wizard.Com.Br Loc:IN   |   Ssis Interview Questions   |   Data Transformation Services   |   DTS Designer Interview Questions   |   DTS And SSIS Similarities   |   Data Transformation Services Interview Questions   |   Ssis Vs Dts   |  
Google : 582 times | Yahoo : 69 times | Bing : 266 times |