Overview
The EDI Source Component is an SSIS Data Flow Component for parsing EDI format files via an EDI Configuration File. The component has already been successfully used to process 210, 271, 277, 810, 812, 820, 822, 832, 834, 835, 837, 850, 852, 855 X12 and D95B EDIFACT formats.
COZYROC offers consulting services, in case you don't have the resources internally to build the configuration file. For details, contact us.
The latest EDI Source has now a custom editor to select the EDI Connection Manager and configure the InsertSequenceTerminator property. In 2.2, there is also added an optional selection for variable as the source of the EDI data, which can be `string` (the EDI messages) or `object` (for streaming EDI data).
Demonstration
Case Study
Parameters
General
In 1.9 use the General page of the EDI Source dialog to configure the component. For older versions of the EDI Source, use the standard Advanced Editor.
Select an existing EDI connection manager.
Indicates whether an empty line should be inserted at the end of each repeating segment (related to composite records support). The default is false.
Options Description True Empty line will be inserted. False Empty line will not be inserted. Specify the EDI Configuration File.
Indicate whether or not the input file name is stored in a variable. This parameter has the options listed in the following table.
Value Description True The input file name is stored in a variable. Selecting this value displays the dynamic parameter InputFileVariable. False The input file name is specified. Selecting this value displays the dynamic parameter InputFile. Select the input file name.
Select an existing user-defined variable, or click <New variable...> to create a new variable.
Related Topics: Integration Services Variables, Add Variable
Type Usage string The EDI messages text. object Stream variable for EDI data (often used with File Transfer Task). Override the segment delimiter loaded from the configuration file. This parameter is not visible in the setup dialog, but can be set in the data flow task properties pane.
Override the field delimiter loaded from the configuration file. This parameter is not visible in the setup dialog, but can be set in the data flow task properties pane.
Override the component delimiter loaded from the configuration file. This parameter is not visible in the setup dialog, but can be set in the data flow task properties pane.
Override the sub-component delimiter loaded from the configuration file. This parameter is not visible in the setup dialog, but can be set in the data flow task properties pane.
Specify the column length for EDI elements. The default is 250.
Knowledge Base
- How to remove the segments in Edi File if all the segment elements are empty?
- Where can I find the documentation for the EDI Source?
- How to exclude EDI elements you don't need from data flow
- How to upgrade to use the EDI Connnection Manager, introduced in 1.9 version?
- Error Message: Must be a minimum of 1 instances of segment []. Currently at segment number
Related scripts
Samples
What's New
- New: Support for stream input.
- New: A new optional attribute segname for segment element in configuration file. If specified, the component will provide segment name information.
- Fixed: Incorrect processing of escaped symbols when multiple delimiter symbols were specified (Thank you, Gavin).
- New: A custom editor to replace the basic one.
- New: All previous configuration properties are now available in the new EDI Connection. This is the recommended way of configuring the component.
- New: A new parameter InsertSequenceTerminator to support "composite records"-compatible formatting of output data.
- New: A new configuration parameter escape. The parameter allows specification of escape combination to handle special control symbols like segment delimiters used in the data.
- New: Component now setups data flow outputs only for looping segments. The previous setup logic will stay the same for existing packages for backwards compatibility.
- New: Component now provides better diagnostic when column processing fails.
- New: Component now supports removal of unused outputs and columns.
- New: A new parameter skipCharacters configuration file. Used for specifying characters, which has to be ignored. This option obsoletes skipNewline parameter.
- New: A new optional attribute segid for segment element in configuration file. If specified, the component will provide segment identity information.
- New: A new parameter undefinedFail in configuration file. If set to false, the component will not fail when new fields, components and sub-components appear in the input file.
- New: A new parameter ColumnLength to specify column length of EDI elements.
- Fixed: Failed to load configuration files containing special characters like 1D, 1E, etc (Thank you, Bryan).
- Fixed: Component didn’t provide useful diagnostic information when loading configuration file with errors.
- New: A new parameter skipNewline in configuration file for avoiding formatting carriage return / line feed characters.
- New: Component can now match segments by specifying a regular expression in segcode configuration parameter. Also the sub-segments data flow outputs now include the parent segment fields.
- Fixed: Component did not process sub-segments properly.
- New: Introduced component.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.