p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server DTS (http://p2p.wrox.com/forumdisplay.php?f=108)
-   -   DTS Package, XML task. Read XML file and store it (http://p2p.wrox.com/showthread.php?t=45646)

Victoria July 24th, 2006 02:43 PM

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.


All times are GMT -4. The time now is 08:17 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.