Answer / gsreddy

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

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

0 Answers   MCN Solutions,

---

What is normalization process?

0 Answers  

---

What are partitioned views and distributed partitioned views?

0 Answers  

---

How to convert a table data in XML format in sql server?

0 Answers  

---

What is 2nf example?

0 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

What are indexes in sql?

1 Answers  

---

What is the New in SQL server 2008?

0 Answers  

---

What is INTVAL( )and where we use Plz any body help me

1 Answers  

---

Write a query to get all details of employee who has maximum salary from employee table

8 Answers   AON, Genpact,

---

Can two tables share the same primary key?

0 Answers  

---

What happens if you add a new index to large table?

0 Answers  

---