EDI x12 output from ssis

• joeroshan

  SSChampion

  Points: 10377

  More actions

  December 10, 2012 at 10:54 pm

  #267301

  Hi,

  I have a requirememnt converting few pervasive maps to SSIS packages.

  We have couple of maps that has EDI x12 (837) output.

  Is there any thirdparty component that can be used in ssis to create EDI file.

  Thanks

  ----------------------------------------------------------------------------------------------------------------------------------------------------
  Roshan Joe

  Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

• Wesley.Groleau

  SSC Enthusiast

  Points: 175

  More actions

  July 27, 2013 at 9:45 am

  #1636404

  I haven't yet done any, but I am about to do so.

  I have used script components to parse complicated flat files (not X12) and output data flows, and reading data flows to write output files.

  I have also created non-SSIS dot-Net programs that make DB calls and put the results into X12.

  Should be simple to paste the latter code into a script component, tweak it to make VSTA happy, and steal bits of my older work from the former.

  I guess I'll know in a week whether my "Should be simple" was mistaken. 🙂