|
|
 next
|
  Subject: Exporting XML to a relational database
Author: Julie Green
Date: 11 Oct 2005 02:20 PM
|
I found my error. When defining the output file, I manually typed in my relational database datasource. When I went back to that dialog box, and selected it using the "..." button, it prompted me with whether or not to overwrite the existing datasource. I said "yes", then the next time I clicked the green triangle (Previewing results of the transformation), the Insert statement ran and the data from my XML file was inserted into the database. Incidentally for those who are as clueless as I was, I also found (in the documentation) that the INSERT statement of the datasource is only performed when the datasource is saved. This is why I had to say "yes" to overwriting existing files, so that when the transformation runs, it saves the datasource, thus triggering the INSERT statement. Not very intuitive, but it works.
|
|
|
|
top