The easiest way is to just create an active x script to load your xml and then insert the data. Here is a example of something that I do to load some xml from a source into a table.

	dim objADOCnn,
	Set objADOCnn = CreateObject("ADODB.Connection")
	
	dim strConnectionStr
	strConnectionStr = "DRIVER={SQL Server};SERVER=***;UID=***;PWD=****;"
	objADOCnn.Open strConnectionStr


		dim oXMLDoc, myXMLQuery
		set oXMLDoc = CreateObject("Msxml2.DOMDocument")
		oXMLDoc.async = false

		myXMLQuery = "http://your.xmlsource.com/document.xml"

		if oXMLDoc.load(myXMLQuery) then
'Do something with your xml data
			objADOCnn.execute("updateData '" & oXMLDoc.xml & "'")
		else
			'Error... No News Data Retrieved
		end if
					
		set oXMLDoc = nothing

	objADOCnn.Close
	set objADOCnn = nothing

This sould get you started.

>Hello Eric,
>
>>Are you asking how you can get xml data into DTS or out of DTS?
>I want to get XML Files via DTS into SQL Server.
>Thanks in advance
>Marcus