EDI Source

Overview

EDI Source Component is SSIS Data Flow Component for parsing EDI format files. The configuration options are provided in the standard data flow source component dialog.

Setup

Use the options below to setup the EDI component.

Options

Configuration

Specify EDI configuration file. Check below for more information about the configuration format.

IsInputFileVariable

Indicates whether the input file name is stored in a variable. This property has the options listed in the following table.

Value	Description
True	The input file name is stored in a variable. Selecting the value displays the dynamic option InputFileVariable.
False	The input file name is specified. Selecting the value displays the dynamic option InputFile.

InputFile

Select input file name.

InputFileVariable

Select an existing user-defined variable, or click <New variable...> to create a variable.

Related Topics: Integration Services Variables, Add Variable

Configuration file

The EDI source component configuration is XML file based on the Milyn EDI message mapping schema. These are the configuration elements:

edimap

This is the top level root element of the XML document.

Element relationships

Relationship	Element
Parent elements	<none>
Child elements	description, delimiters, segments

description

This element contains user-friendly description of the configuration file.

Attributes

Attribute	Description
name	Description of configuration file.
version	Version of configuration file.

Element relationships

Relationship	Element
Parent elements	edimap
Child elements	<none>

delimiters

This element contains the EDI file delimiters for segment, field, component and sub-component parts. Special characters like line feed character are specified using XML Character References.

Attributes

Attribute	Description
segment	Segments delimiter character.
field	Fields delimiter character.
component	Components delimiter character.
sub-component	Sub-components delimiter character.

Element relationships

Relationship	Element
Parent elements	edimap
Child elements	<none>

segments

This element groups segments read from the EDI file.

Attributes

Attribute	Description
xmltag	Name of the segments group.

Element relationships

Relationship	Element
Parent elements	edimap
Child elements	segment

segment

This element specifies EDI segment. Each segment is represented as Output in the SSIS data flow. You can specify multiple segments.

Attributes

Attribute	Description
segcode	Code found in the EDI file, which establishes mapping relationship to this segment.
xmltag	Name of the segment.
truncatable	When set to true, the parser will not generate errors when the segment does not contain trailing fields, components, sub-components, which are not required.

Element relationships

Relationship	Element
Parent elements	segments
Child elements	field

field

This element specifies EDI field. Each field is represented as column in the SSIS data flow. You can specify multiple fields.

Attributes

Attribute	Description
xmltag	Name of the field.
truncatable	When set to true, the parser will not generate errors when the field does not contain trailing components, sub-components, which are not required.
required	Specifies whether the field is required. By default it is set to false.

Element relationships

Relationship	Element
Parent elements	segment
Child elements	component

component

This element specifies EDI component. Each component is represented as column in the SSIS data flow. You can specify multiple components.

Attributes

Attribute	Description
xmltag	Name of the component.
truncatable	When set to true, the parser will not generate errors when the component does not contain trailing sub-components, which are not required.
required	Specifies whether the component is required. By default it is set to false.

Element relationships

Relationship	Element
Parent elements	field
Child elements	sub-component

sub-component

This element specifies EDI subcomponent. Each subcomponent is represented as column in the SSIS data flow. You can specify multiple subcomponents.

Attributes

Attribute	Description
xmltag	Name of the subcomponent.
required	Specifies whether the subcomponent is required. By default it is set to false.

Element relationships

Relationship	Element
Parent elements	component
Child elements	<none>