sql server dts: Include file doesn't work with SSIS 2005 XML Task ? -- sql server dts

Include file doesn't work with SSIS 2005 XML Task ?

funkeymonkey
8/3/2006 8:54:30 AM

sql server dts:

Hi,
We have a requirement to use XSLT to transform data into flat text
before loading it into SQL.
We use a function to strip funny chars out of the file.
If we retain the function within the XSLT it works fine, but if we
include it as a separate text file (either locally or on our web server)
the package fails with an 'xslt compile error'.
Has anyone come across this before ?
The offendling line is here :
<xsl:include
href="C:\sourcecode\SourceSafe\Development\Inventory\DataLoad\Source\Res
ources\Postar_Functions_Strings.xslt"/>

Thanks.

Tim Heap
Software & Database Manager
POSTAR Ltd
www.postar.co.uk
tim@postar.co.uk

RE: Include file doesn't work with SSIS 2005 XML Task ?

Charles Kangai
8/6/2006 4:11:02 AM

Hi Tim,

In my experience, this error occurs if copying and pasting the entire
contents of the included file at the position of the xsl:include element
would not have produced a well-formed or valid XML document. The <xsl:include
.... /> does no more than copy and paste the entire included document at that
position, except that it does it in memory at run time. If the result is not
a well-formed or valid XML document, you will get a compile error.

To debug the problem, try copying and pasting the entire included xslt
document in place of the <xsl:include .../> and see whether it works.

Cheers,

Charles Kangai, MCT, MCDBA

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.