I am working on a project which requires that all data be transported in XML
and fed directly into DTS. I have created parameterized templates which
return the needed data. However, I haven't been able to find a way to pull
this directly into my DTS packages.

Is there a way to make a call to a URL containing a SQLXML template and
import the returned XML data directly into a DTS Package?

Many Thanks,
Rob