Using Data Transformation Services, part 5: Package Execution with ASP.NET - Part B: Create a Web project
(Page 3 of 5 )
In the Visual Studio 2003 IDE, go to File-->New--> Project. This opens up the New Project Window, where you choose to create an ASP.NET Web application (named DTS in this tutorial). Rename the WebForm1.aspx to some chosen name (ExecPackage in this tutorial). Your Solution/Project would appear as shown here.
Add references to DTS COM Assemblies In order to access the DTS properties and methods, we need to add appropriate references. Right click the References tab and click on Add reference.... This brings up the Add Reference window, where you can establish references to .NET, COM, or Projects. DTS is to be accessed as a COM interface, so go to the COM tab. Scroll down to see whether DTS related assemblies are available. If they are, you can select them and add them to the References node.
After adding this, you will be able to access the properties and methods of DTS objects. If not, you use the Browse... button to locate those files and add them to the references of your application. They should be found in the Program Files folder at a location similar to the following: C:\Program Files\Microsoft SQL Server\80\Tools\Binn. This is shown in the following picture.
There are two files that may be needed, dtspkg.dll and dtspump.dll. In this tutorial we will be using only the dtspkg.dll file. The dtspump.dll file is needed mostly for leveraging ActiveX scripting support.
With these references added, your project would appear as shown in the next picture. Also shown is the object browser for the project. You can see the Interop.DTS and Interop.DTSPUMP assemblies in the listing.
Next: Write simple code to execute the package >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
/ 13 
