Executing an XTM |
|
After creating the XTM and saving it as an XSL file, you can pass data from the source XML file to the database by executing the XTM. When executing the XTM, you can choose to save the data as an XSL file and run the XTM, or save the transformation as an SQL script. Saving as an SQL script will not enter any data into the database. You must execute the script to enter the data into the database.
If you are trying to automate data transfer using a data transfer API or stored procedure, then you should save the transformation as an XSL file.