I am creating a package using SQL Server 2005 Integration Services.
I have .XML file where is stored Path of MS Access file.
I want "XML task" to read this .XML file and store Path value in the
package level User::AccessPath variable. My construction does not work.
If anybody knows why, please, help!

XML Task Editor: properties that I have set up :


Input
   OperationType: XPATH
   SourceType: File connection
   Source: ConnectionProfile.xml
Output:
   SaveOperationResult: True
   OperationResult:
       Destination: User::AccessSource
       DestinationType: Variable
       OverwriteDestination: True
Second Operand:
   SecondOperandType: Direct input
   SecondOperand: /dsPDM/tblSourceConnection/Path
XPATH Options:
   PutResultInOneNode: False
   XPATHOperation: Values


******************* ConnectionProfile.xml **************************
<dsPDM xmlns="http://tempuri.org/dsPDM.xsd">
  <tblSourceConnection>
    <ConnectionName>Access</ConnectionName>
    <Path>C:\Access\Local\db1.mdb</Path>
  </tblSourceConnection>
</dsPDM>
***********************************************




Thank you,
Victoria.