Greetings Al

I have the an issue with the following line not working in VS Biz
Studio SSIS:
<xsl:value-of
select="document('')//lk:definitions/lk:acct[@name=$curBankID]/lkarent_key"/>

There is some embedded xml in the sheet that is used as a source for a
lookup. It works fine in XMLSpy, Vis Studio but not in an integration
package. I have tried using hard coded paths, rewritten the whole
thing using key(), etc. but to no avail.

Anyone have any ideas?

Cheers

mma


source xml file

<?xml version="1.0" encoding="utf-8"?>
<mb>
<accounts>
<reporting_date>2001-12-17T09:30:47.0</reporting_date>
<production_date>2001-12-17T09:30:47.0</production_date>
<organisation>HBL</organisation>
<amount>3.1415926535897932384626433832795</amount>
<bank_id>1000</bank_id>
<parent_Key>100</parent_Key>
</accounts>
<accounts>
<reporting_date>2001-12-17T09:30:47.0</reporting_date>
<production_date>2001-12-17T09:30:47.0</production_date>
<organisation>HBL</organisation>
<amount>3.1415926535897932384626433832795</amount>
<bank_id>1005</bank_id>
<parent_Key>101</parent_Key>
</accounts>
</mb>

XSLT file
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0" xmlns:lk="http://www.mma.gov.mv"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:fn="http://www.w3.org/2005/02/xpath-functions"
xmlns:xdt="http://www.w3.org/2005/02/xpath-datatypes"
exclude-result-prefixes="xdt fn xs xsl lk">
<xslutput version="1.0" encoding="UTF-8" indent="yes"
omit-xml-declaration="no" media-type="xml"/>

<xsl:template match="/">
<!--main routine to reformat the data-->
<mb>
<xsl:for-each select="/MB/*/@BANK_ID">
<xsl:variable name="curBankID" select="."/>
<accounts>
<reporting_date>
<xsl:value-of
select="/MB/Reporting_Date"/>
</reporting_date>
<production_date>
<xsl:value-of
select="/MB/Production_Date"/>
</production_date>
<organisation>HBL</organisation>
<amount>
<xsl:value-of select=".."/>
</amount>
<bank_id>
<xsl:value-of select="."/>
</bank_id>
<parent_Key>
<xsl:value-of
select="document('')//lk:definitions/lk:acct[@name=$curBankID]/lkarent_key"/>
</parent_Key>
<unaryColumn>
<xsl:value-of select="./UnaryColumn"/>
</unaryColumn>
<SCD_ID>
<xsl:value-of select="./SCD_ID"/>
</SCD_ID>
<SCD_Start_Date>
<xsl:value-of
select="./SCD_Start_Date"/>
</SCD_Start_Date>
<account>
<xsl:value-of select="./Account"/>
</account>
</accounts>
</xsl:for-each>
</mb>
</xsl:template>
<lk:definitions>
<lk:acct name="1000">
<lk:bank_id>1000</lk:bank_id>
<lk:unarycolumn>+</lk:unarycolumn>
<lkarent_key>100</lkarent_key>
<lk:scd_id>1000</lk:scd_id>
<lk:account>In National Currency</lk:account>

<lk:scd_start_date>2006-01-01T00:00:00.00</lk:scd_start_date>
</lk:acct>
</lk:definitions>

</xsl:stylesheet>