We help IT Professionals succeed at work.

How do I use SSIS to load a EDI file

guspan
guspan asked
on
Medium Priority
1,832 Views
Last Modified: 2013-11-10
What is the best method for loading a EDI file is SSIS?
Comment
Watch Question

Commented:
Can you convert the EDI to XML?
Regards,
Pedro
www.pedrocgd.blogspot.com
CERTIFIED EXPERT
Commented:
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..

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Commented:
I wasted my free trial of one solution on this.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.