Step 3: Building the BI project and Executing
the Package
1. Right-click the WSVC project in the Solution Explorer and click on Build
in the drop-down menu. After the Build succeeds, click on the MileKm.dtsx
and execute the package.
After the package has run the CnvrtMilesToKilo web service, the task turns
green and will have created the file WebServiceTaskOutput. The next screenshot
shows a display of the file when opened with Notepad. The file was not
given any extension, but it happens to be an XML file. The result of converting
20 miles yields 32.186 kilometers.
Web Service Task to Convert Miles to Kilometres
[ 226 ]
Summary
This chapter described the usage of the Web Service Task in the SSIS Editor. A
simple web service was described. Compared to other chapters, the Visual Studio
2005 Solution consists of two parts, both of which were shown in detail. It is
recommended that you review some of the articles on web services, whose links
have been provided, as well as get a working knowledge of the scope and extent of
web services from the W3C site. It would have been a lot easier (user friendly) if the
tool would take a URL reference rather than a file reference.
Package that Transfers a
Database from One SQL
Server to Another
Database migration from one version of SQL Server to another version, database
consolidation, and addressing availability issues by duplication to another remote
standby location are some of the scenarios where you need to transfer or copy
a database.
Pages:
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162