Both the web service as well as the Business Intelligence Package
will be parts of a Visual Studio 2005 solution.
Part One
In this part, a web service that converts miles into kilometers will be described.
This program, that is going to be hosted on the localhost, can be accessed using the
HTTP protocol.
Step 1: Create a Visual Studio 2005 Blank Solution
In this chapter, we will be creating more than one type of project in a
VS 2005 solution.
1. Create a solution Ch 14 from File|New|Project.
This opens the New Project window, as shown in the following screenshot.
Chapter 14
[ 215 ]
2. Click on the Other Project Types and in Visual Studio installed templates
choose Blank Solution.
3. Change the Name field to Ch 14.
A Visual Studio blank solution Ch 14 will be created.
Step 2: Create a Web Service
1. From File|Add |New Web Site... create a new ASP.NET website
SSIS_SVC on the localhost.
This adds the site http://localhost/SSIS_SVC/ to the Solution.
2. Right-click after highlighting http://localhost/SSIS_SVC/ in the Solution.
3. In the drop-down, click on Add New Item...
This opens the Add New Item window, as shown below.
4. Highlight Web Service in the Visual Studio installed templates.
This adds a default name WebService.asmx.
Web Service Task to Convert Miles to Kilometres
[ 216 ]
5. Change the name to ForSsis.asmx and click on the Add button.
This adds a ForSsis.vb file to the App_code folder of the
http://localhost/SSIS_SVC website and a ForSsis.
Pages:
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156