XML from DTS Tranform task

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Wayne Antinore (wantinore_at_veramark.com)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 08:49:35 -0500

Hi,
I'm trying to use a DTS transform task to output the results of a query that
has the For XML syntax. I define the source and make a text file
destination and everything seems to work fine but when I open the output
.XML file it is just a bunch of Hex data. Is there some type of pre or post
source function I need to do on the transformation phases?

I have been able to do this by creating an active X script task and running
that as a DTS package but I originally wanted to do this through DTS for
performance. I think the active X script task won't have any better
performance than a dll or an executable.

I've seen other people asking how to do this but the only answer I've seen
is the active X script so maybe it cannot be done. Right now we are calling
the BCP library routines to do this in a C++ dll but since that depends on
older DB-Library routines I would rather use something else.

  Thanks in advance for any help.

    Wayne Antinore

Relevant Pages

  • Re: Help understanding SSIS !
    ... SSIS is a very different beast to DTS and some of the thought processes need to be rethought also. ... I have several dts packages that are simply vbscripts that I want to ... I was able to create a package be dropping an Active X script Task ...
    (microsoft.public.sqlserver.dts)
  • Re: Can I call a Script Task from other Script Task?
    ... OK so in your original post there was no mention of SSIS and this is the ..dts NG so I took it to be DTS. ... This is by design to stop us playing with things and causing an unstable package. ... script Task in 'SSIS 2005 Package' from other Script Task in same ...
    (microsoft.public.sqlserver.dts)
  • Re: dts Logging
    ... You can write to the log but ONLY from the AX Script task using ... www.SQLDTS.com - The site for all your DTS needs. ... > DTSRun: Executing... ... The task reported failure on execution. ...
    (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)