dbTalk Databases Forums  

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

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Include file doesn't work with SSIS 2005 XML Task ? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
funkeymonkey
 
Posts: n/a

Default Include file doesn't work with SSIS 2005 XML Task ? - 08-03-2006 , 10:54 AM






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\Invento ry\DataLoad\Source\Res
ources\Postar_Functions_Strings.xslt"/>

Thanks.


Tim Heap
Software & Database Manager
POSTAR Ltd
www.postar.co.uk
tim (AT) postar (DOT) co.uk

*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote
  #2  
Old   
Charles Kangai
 
Posts: n/a

Default RE: Include file doesn't work with SSIS 2005 XML Task ? - 08-06-2006 , 06:11 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



"funkeymonkey" wrote:

Quote:
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\Invento ry\DataLoad\Source\Res
ources\Postar_Functions_Strings.xslt"/

Thanks.


Tim Heap
Software & Database Manager
POSTAR Ltd
www.postar.co.uk
tim (AT) postar (DOT) co.uk

*** Sent via Developersdex http://www.developersdex.com ***


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.