Wednesday, December 29, 2010

Importing XML Source Definition

Open the Designer and click the --> Source Menu --> Import XML Definition
Select the XML file you want to import and then click open


Specify the Naming options for the XML

Next, the window looks like this, click next

After the XML file is imported this how it looks in Source Analyzer.

Create a Target Definition for the output, here in this example I have created a flat file which looks like this.

Drag the source and Target Definitions into the Mapping Designer workspace and link the ports

Create a session and assign it with the mapping above created

Create a workflow and drag the session into the workspace and link together

In the session Mapping Properties make sure the source file name and the path.

Save the repository and run the task.

No comments:

Post a Comment