Using Data Transformation Services: Can We Transfer XML Data? - DTS Design Details

(Page 3 of 5 )

First of all, I will be using a Global Variable NewXMLDTS and into this I will be stuffing the result of my query. The next picture shows the Global Variables tab of the DTS Package Properties. The Type is shown as Dispatch in this picture, as the program had finished executing when the picture was captured. Initially it would be <other>. The name Newxml is not used in this tutorial.

Next I will be using an ExecuteSQL Task which uses the connection that I have established. This process has been described a number of times and will not be repeated. The next two pictures show the two relevant portions of this ExecuteSQL task.

This picture shows the Parameter mapping accessed by clicking the Parameters... button. Notice that the same characters that are in the Query Analyzer are also in the mapped parameter.

Next: The ActiveX Script >>
 

More Database Articles
More By Jayaram Krishnaswamy

Comments On: Using Data Transformation Services: Can We Transfer XML Data?

· Here is another interesting tutorial on DTS as related dealing with XML. There are...   >>> Post your comment now!