O'Reilly logo

SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Hands-On Exercise 1: XMLTask type Diff

In this exercise we will use the two documents, webstudentsOK.xml and webstudentsOK2.xml, and generate a DiffGram document that shows the difference between the two documents.

Step 1: Create a BI Project and Add a Control Flow task, XMLTask

This process has been described a number of times in the previous chapters.

Create a BI project, Ch11. Change the name of the default package name to XMLDiff.dtsx. Drag and drop an XMLTask from the Control Flow Items group in the Toolbox to the Control Flow page on the Canvas. An instance of XMLTask will be added to the Canvas on the Control Flow page.

Step 2: Configuring XMLTask

  1. 1. Right-click on the XMLTask component on the Canvas, and from the drop-down menu, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required