NEW: Check our new hosted service COZYROC Cloud ...

COZYROC

SQL Server Integration Services (SSIS) components, tasks, scripts and productivity tools.

Products

SSIS+ Components Suite

Comprehensive suite of 200+ components for developing rock solid ETL solutions with Microsoft SQL Server Integration Services.

Learn more

SSIS NoW

Event-based processing using the same SSIS technology we all love.

Learn more

Excel Add-in for SAS

Process SAS system data set files from within Microsoft Excel.

Learn more
Partners
Find a Partner

Become a Partner

Partner Sales Registration
Download
Purchase
PayPal

Purchase Orders
Support
Help Center

Installation and Getting Started

Licensing

Tutorial Videos

Forum

Release Notes
Blog
About Us
About Us

News

Testimonials

Case Studies

Contact Us

EDI Connection

Overview
Parameters
Knowledge Base
What's New

Overview

EDI EDI Connection Manager is SSIS Connection Manager for for configuring settings of EDI Source (after 1.9) and EDI Destination. It allows specifying the path of the EDI Input / Output File and the EDI Configuration File. The editor also displays the structure of the currently loaded EDI configuration.

Parameters

General

EDI File
The path of the input/output EDI file (depending on usage context):
- Input EDI File when used by EDI Source
- Output EDI File when used by EDI Destination
EDI File Encoding
2.0 SR-1

Select the used encoding for the EDI file.

Design-Time

EDI Configuration

An EDI document is comprised of data elements, segments and envelopes that are formatted according to the rules of a particular EDI standard. To be able to parse or generate EDI files, it's necessary to specify a EDI Configuration that describes those rules in XML format.
Column Length

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 Connection?
Error Message: Must be a minimum of 1 instances of segment []. Currently at segment number
I want to use your EDI Source component. Where can I get the XML configuration file for the specific format I want to process?
Error Message: The connection type "xxxx" specified for connection manager "xxxx" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.

What's New

2.0 SR-1

New: A new parameter CodePage to set the used code page for the EDI file.

1.9 SR-3

Fixed: Failed with error "This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms" (Thank you, Ethan).

1.9

New: Introduced connection.

Related documentation

EDI
EDI Configuration
EDI Destination
EDI Source

COZYROC SSIS+ Components Suite

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.

Download Now!

Newsletter

Join VIP subscribers getting Exclusive COZYROC SSIS+ Library updates, private Q&A and more.

Enter your email here: *

No spam, ever. Just great stuff !

Twitter Feed

How to set up a simple Inbound Webhook that triggers the execution of a package in the #COZYROC #Cloud… https://t.co/EMhzFr5NxH

🔔 Official release of #COZYROC SSIS+ 2.1 version is now public https://t.co/Zf8bSHcVdB ⭐ Support for 31 additional… https://t.co/7I6ToLFQXq

#CapsuleCRM #SQLServer REST SSIS integration. CapsuleCRM connection, Data import / Export to SQL Server. Demo video… https://t.co/95FsOphE53

Contact Us

Address: 4350 Lassiter at North Hills Ave, Raleigh, NC 27609, United States
Phone: +1 (919) 249-7421
Support: Help Center

Follow Us

Support

Help Center
Getting Started
Licensing
Tutorials
Forum

Contact
Terms
Privacy

2006-2022 COZYROC LLC ♡ Made with Love