View Single Post
  #1 (permalink)  
Old July 24th, 2006, 02:43 PM
Victoria Victoria is offline
Registered User
 
Join Date: Jul 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default DTS Package, XML task. Read XML file and store it

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.