How do I use SSIS to load a EDI file

Posted on 2009-02-09
Last Modified: 2013-11-10
What is the best method for loading a EDI file is SSIS?
Question by:guspan
    LVL 22

    Expert Comment

    Can you convert the EDI to XML?
    LVL 17

    Accepted Solution

    If you know the file layout then reading an EDI file should be no different than reading any other delimited or fixed length file. Usually EDI will be delimited by tab or space, but it could be anything. I reccommend a Flat File connection. Is it delimited or fixed length, choose your file connection. Add any data conversions or derived columns to trim spaces, etc..

    Expert Comment

    I wasted my free trial of one solution on this.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now