See BI project, SSIS;
[ 298 ]
C
Character Map Data transformation 102
Conditional Split Data Transformation
about 135
adding 137
BI project, creating 136
configuring 137-139
data flow task, adding 136
DataReader source, adding 136
DataReader source, configuring 136
DataReader source, connecting 137
data transferring, from flat file to SQL
Server database table 135, 136
package, executing 145
path, establishing 137
project, building 145
recordset destination, adding 140
recordset destination, configuring 141-144
results, reviewing 145
steps 135, 136
D
Data Conversion Data Flow transformation
about 159
Access Destination 160
adding 165, 166
BI project, creating 162-165
configuring 167, 168
DataConvert 160
data flow task, adding 162-165
data transferring, to Excel file 162
Excel source 160
Excel source, configuring 162-165
OLE DB data destination 160, 161, 168
package, testing 173, 174
path establishing, from Excel source
166, 167
project, building 173, 174
recordset destination, adding for displaying
errors 172, 173
recordset destination, configuring for
displaying errors 172, 173
steps 162
data flow components, SSIS
data flow destinations 21, 22
data source components 12-14
data transformation 14, 16
data transformation
about 14, 15
contributing, to package design 16-21
Data Transformation Service 7
Diff, XMLTask type
BI project, creating 179
control flow task, adding 179
documents 177
exercise 179
XMLTask, configuring 180-184
DTS 7, 251
E
ETL 7
event handler, SSIS
about 239
BI project, creating 240, 241
default package, renaming 240, 241
Execute Package task, adding to OnError
event 244, 245
Execute Process task, adding to
OnPostExecute event 246
Execute SQL task, adding 242-244
Execute SQL task, configuring 242-244
package, adding 241
package, configuring 241
package, executing 248
project, building 248
project creating, with two packages 240
Excel file
BI project, creating 100
Character Map transformation, adding
102-106
data, transferring 99
data flow task, adding 100
DataReader??™s connection manager,
configuring 100
DataReader source, configuring 102
Excel destination, adding 106
Excel destination component, configuring
107-109
package, testing 110
path establishing, from Character Map to
Excel destination 106
[ 299 ]
F
FileSystemObject 187
File System Task, SSIS
BI project, creating 188
configuring 189-191
Control Flow task, adding 189
file, copying from one folder to another 188
file, sending by Send Mail task 188
operations 188
Send Mail task, adding 192-194
steps 188
File Transfer Protocol.
Pages:
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200