See SMTP server
SMO connections 227
SMTP server
about 75
email, sending 75-83
ISPs SMTP server, finding 84
solution explorer
about 48-52
SQL Management Object connections 227
SQL Server Integration Services. See SSIS
SSIS
about 7, 8
ActiveX Script task 263
BI project 28
data flow components 239
debugging feature 26
diagnostic feature 26
event handler 239
export wizard, invoking 72, 73
features 26
FileSystemObject 187
File System task 187
import wizard, invoking 72, 73
Maintenance Plan task 287
objects 9
package, importing 69-72
Script task 273
tasks 10, 12
Transfer Database task 228
windows, getting acquainted with 69
SSIS package
creating, to access files 187
creating, to access folders 187
creating, with XML task 175
XMLTask 175
T
Text file
BI project, creating 88
connection manager for DataReader,
adding 88-90
data, transferring 87
data flow task, adding 88
DataReader source, configuring 90-93
Flat file destination, adding 93
Flat file destination component, configuring
94-97
package, building 97
package, executing 97
path establishing, from DataReader
source 93
Transfer Database task
about 227
adding 229
BI project, building 236
BI project, creating 229
configuring 229, 230
connections, establishing 231, 232
[ 301 ]
database transferring, from one SQL server
to another 227
database transferring, from SQL server 2000
to SQL server 2005 227
database transferring, ways 227
destination database, configuring 235
network share, creating 228
package, creating 228
package, executing 236
package, testing 228
SMO connections 227
source database node, configuring 233, 234
W
Web Services Description Language
about 213
miles into kilometers, converting 214
Web Service task, SSIS
about 213
adding 219, 220
BI project, building 225
BI project, creating 219, 220
configuring 220-225
features 213
package, creating 214
package, executing 225
package, testing 214
Visual Studio 2005 solution, creating
214, 215
web service, creating 215, 216
WSDL file, creating 217, 218
windows
about 53, 54
Bookmark window 55
Class View window 56
Code Definition window 56
Debug window 65
Error List window 58
Find Results window 60
Object Browser window 56-58
Other Windows 63, 65
Output window 58
Properties window 58
Property Pages window 67
Server Explorer window 54
solution explorer 48-52
Tasks List window 60
Toolbox window 60
WSDL 213
X
XML documents 176
XMLTask, SSIS
about 175
Diff task 175, 176
merge task 176
task types 175
validate task 176
XPATH task 176
XSLT task 176
XSLT, XMLTask type
documents 178
exercise 184, 185
Thank you for buying
SQL Server Integration Services
Using Visual Studio 2005
About Packt Publishing
Packt, pronounced 'packed', published its first book "Mastering phpMyAdmin for Effective
MySQL Management" in April 2004 and subsequently continued to specialize in publishing
highly focused books on specific technologies and solutions.
Pages:
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200