The input list can be sorted in multiple ways,
starting from the lowest column sort order. As the data to be sorted may contain
strings, a string of comparison options can be defined for this transformation.
Unsorted columns have a sort order of 0.
Term Extraction
This transformation is basically used with text data of type DT_WSTR or DT_NTEXT.
This transformation extracts nouns only, noun phrases only, or noun and noun
phrases. It cannot extract articles, verbs, adjectives, pronouns, etc. and it writes the
extracted items to a transformation output column. The transformation works only
for English language and uses an internal dictionary to aid in the extraction. The
transformation normalizes the case of the text extracted by default to lower case.
Union All
This transformation is similar to an SQL statement with a UNION ALL clause. You can
combine the values of two sources to create a combined source containing inputs in
the sense of an SQL statement. The two sources should have the same metadata for
this to work.
Chapter 1
[ 21 ]
Unpivot
This transformation is the reverse of the pivot transformation mentioned earlier.
Data Flow Destinations
Similar to the data flow sources, the SSIS designer provides a number of data flow
destinations. The data is written to the destination data store or to an in-memory
data set. The destination must have a minimum of one input. As will be seen, the
input may be a column, or columns from a source table after undergoing some
kind of transformation.
Pages:
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40