ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
   
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


  

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
Difeerence between ssis 2005 and ssis2008?
 Question Submitted By :: Gsreddy
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Difeerence between ssis 2005 and ssis2008?
Answer
# 1		 There is no difference between the architecture of both the
SSIS 2005 and SSIS 2008. 2008 has some additional features
which 2005 did not have, it can be said that 2008 is the
enhancement of features to the 2005 version.


Look-up

In 2005 for Error Output look-ups had only 3 options Fail
Component, Ignore Failure and Re-direct row. But in 2008 it
has an additional feature “No match Out-Put”
In 2005 it did not had the Cache mode, while 2008 has 3
different Cache modes Full Cache, Partial Cache and No Cache
2005 didn’t have the Connection Manager types while 2008 has
OLE DB Connection Manager and Cache Connection Manager


Cache Transformation

2005 did not have this transformation; it is introduced in
2008 version. This is a Data-flow transformation. Cache
transformation writes data from a connected data source in
the data-flow to a Cache Connection Manager. The Look-up
transformation in a package performs lookups on the data
In a single package, only one Cache Transformation can write
data to the same Connection Manager. If the package contains
multiple Cache transforms, then first Cache transform that
are called when the package runs, writes the data to the
connection manager. The write operations of subsequent cache
transforms fail.
Configuring of the Cache can be made in the following way
1) Specify the connection manager
2) Map the input columns in the cache
transform to destination columns in the Cache
connection manager


Data Profiling Task

2005 did not have this Task while it is introduced in 2008;
this is a Control-flow task. It lets you analyze data in a
SQL Server database and from the results of that analysis,
generate XML reports that can be saved to a file or an SSIS
variable. By configuring one or more of the task’s profile
types, you can generate a report that provides details such
as a column’s minimum and maximum values, or the number and
percentage of null values.


Script Task and Transformation

2008 gives the option of writing the scripts either in VB or
C#, where as 2005 only enabled the users to write the
scripts in only VB

 
Is This Answer Correct ?    7 Yes 0 No
Gsreddy
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
what r steps to we need to fallow b4 kill the process? Verizon1
What is normalization and what are the different forms of normalizations?  2
What is the difference between temp table and table variable? Microsoft8
What is Full Outer Join?  3
How to Install SQL SERVER 2005 remotely? IBM1
How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that TCS9
Advantages and Disadvantages of Cursor? Zenith15
what is difference between nchar and char in Sql server ?  3
How to find the date and time of last updated table?  3
What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they. IBM5
Difference between Cluster and Non-cluster index? Oracle32
Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer  2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com