Thursday, June 17, 2010


Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services (Wrox Programmer to Programmer)
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

SSIS Interview Questions And Answers

1 comment:

  1. Really helpful to to understand these difference clearly . Thanks :)