In November 2001, Marshall Rosenstein wrote How to Create a Zip Code Webservice. That zip application enabled you to find cities and zip code distances using a combination of a SQL Server 2000 and ASP.NET 1.x web services. The technologies at that time involved SQL Data Transformation Services, T-SQL user-defined functions and procedures, and ASP.NET web services. SQL Server 2005 contains new features that will allow you to create an improved solution architecture for this kind of scenario. In this article, Marshall will show how to use SQL Integration Services to import zip code data, SQL CLR to create stored procedures and user-defined functions, and SQL 2005 HTTP Endpoints to expose the zip code web service. You’ll create a zip code application that runs entirely in SQL Server 2005.

Author:Marshall Rosenstein
Editor:David Schultz
Reviewers:Alex Thissen, Saurabh Nandu