SQLXML Template-Import XML into DTS Package

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rob <Rob@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 17 May 2005 11:13:07 -0700

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

.

Prev by Date: Re: Please HELP! text import problems.
Next by Date: Execute Package Task error
Previous by thread: Dynamic DTS Task Challenge
Next by thread: Execute Package Task error
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL Server 2000 DTS Designer Components
... I seem to remember it taking some effort to get the DTS components working in SQL 2005 x64 also. ... The error was "SQL Server 2000 DTS Designer components are required to edit DTS packages. ... Install the special web download 'SQL Server 2000 DTS Designer Components' to use this feature". ...
(microsoft.public.sqlserver.clients)
Re: DTS and version control software
... my original plan was to store the VB code in source safe and use it to ... > task and then look at each transformation object and get the ... > www.SQLDTS.com - The site for all your DTS needs. ... >>> I'm considering using DTS packages for certain database tasks. ...
(microsoft.public.sqlserver.dts)
Re: XML from DTS Tranform task
... >I'm trying to use a DTS transform task to output the results of a query that ... >.XML file it is just a bunch of Hex data. ... I think the active X script task won't have any better ... You can wrap the ADO in an ActiveX Script Task to fit it into DTS. ...
(microsoft.public.sqlserver.dts)
Re: XML IMPORT
... this site to import XML into SQL using some VB Script in a DTS package, sorry about the long description there, but for some reason I am unable to make it work, I am trying to get a selection of information out of one tag but the DTS says it has completed but nothing is there, I think it has something to do with the way that the XML file is stuctured:- the xml files looks like ... If so I'm wondering if the script is having problems with the second document prologue. ... is SQL Server 2005 and SIS an option for you? ...
(microsoft.public.sqlserver.xml)
RE: Problems with xml bulkload
... you may need to look at what service account DTS ... A _small_ amount of sample data and target table DDL might help too ... ... I have the vbscript below in my dts package and xml schema, ... Set objBulkLoad = Nothing ...
(microsoft.public.sqlserver.xml)