2. Click on the button with the green arrow head, shown in the above screenshot.
The rows with errors are redirected to the Recordset Destination as shown
in the next screenshot. Also notice that the error messages that are in these
rows. Two rows of incoming data violated the schema of the table into which
they were scheduled to be loaded.
3. Click on the button with the green arrow head now.
This will turn all the components green.
On Using a Data Conversion Data Flow Transformation
[ 174 ]
4. Open the Access Destination table in the DataConvert.mdb access file
to review the rows transferred. The next screenshot shows the Access
Destination table in Table View.
.
The two rows with missing AccNames, were the ones that had schema violation
errors. Truncation errors such as this are not serious errors and therefore you still
see a warning symbol on the OLE DB Destination component.
Summary
This chapter described in detail the steps involved in interposing a Data Conversion
Data Transformation and how to guide the rows that violated to another location
for review.
Creating a SSIS Package
with an XML Task
XML, an acronym for Extensible Markup Language recommended by W3C
(http://www.w3c.org/xml/), in 1998 has become the lingua franca of the internet. In
the past ten years it has made tremendous inroads into all activities connected with
the web and largely determines how data is exchanged between businesses. Because
of the precise way data can be defined using a simple and flexible text format, it
is efficient and best suited for data exchange across the internet.
Pages:
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132