See FTP task
FTP task
about 251
BI project, creating 253-256
building 257
default package, renaming 253-256
disabling 257-260
executing 257
files, transferring 251
new FTP task, adding 257-260
new FTP task, building 261
new FTP task, configuring 257-260
new FTP task, executing 261
package, creating 252, 253
M
Maintenance Plan task, SSIS
backup database task 289
backups 287
database, backing up 289
database maintenance task 287
integrity 287
Microsoft SQL server management studio
287, 288
optimizations 287
package, creating 289-295
Ms Access Database
about 111
BI project, creating 112
data, transferring 111
data, viewing 119-121
data flow, monitoring 119-121
data flow task, adding 112
DataReaders connection manager,
configuring 112
DataReader source, configuring 112, 113
data viewer, incorporating 119-121
OLE DB destination, adding 113, 114
OLE DB destination component,
configuring 114-119
path establishing, from DataReader
component 113, 114
O
objects, SSIS
connection managers 22, 23
connection managers, partial listing 23, 24
control flow elements 10
data flow components 12
Event handlers 24, 25
log providers 25
log providers, types 26
SSIS package 10
variables 24
OLE DB data destination
adding, to canvas 168
column, mappings 171
configuring 168
connection manager, setting up 169, 170
data loading errors, handling 171, 172
path establishing, from Data Conversion
Data Flow transformation 168
table, displaying 170
Oracle 10G XE Server
about 200
BI project, creating 203
data flow task, adding 203
object browser, using 201, 202
OLE DB connection manager,
configuring 204
OLE DB source, adding 204
OLE DB source, configuring 205
package, building 212
package, executing 212
path establishing, from OLEDB source to
SQL Server destination 209
SQL Server destination, adding 207
SQL Server destination component,
configuring 210-212
start mode 200
steps 200
[ 300 ]
stop mode 200
View transferring, to SQL Server 2005
database 200
P
package design, canvas
about 37
control flow 38
data flow 39, 40
event handler 41, 42
items, adding in toolbox 44
package explorer 43, 44
toolbox 44
toolbox items 47
Precedence Constraint
about 195
adding 196
package, building 197
package, executing 197
using, to send mail 195
S
Script task, SSIS
about 273
calculating, variables used 278, 279
data, copying to file 284, 285
data, displaying 284, 285
data, retrieving 282-284
line items 275
package, creating 274
simple calculation, example 274-277
string, building 280, 281
Send Mail Task 75
Simple Mail Transfer Protocol.
Pages:
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200