Post reply

How to convert EDI PAD files into SQL Server using SSIS

  • November 6, 2008 at 10:33 pm

    #201280

    Hi,

    How to convert EDI PAD files into SQL Server using SSIS 2005

    any suggestions, links are highly appreciated.

    Thanks,

    Regards,

    Viji

  • November 6, 2008 at 11:29 pm

    #895319

    Hi,

    EDI seem to support OLED/ODBC but you would have to get hold of a driver that can expose those files as an OLEDB datasource.

    http://www.123edi.com/edi-database.asp

    HTH!

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

  • December 29, 2008 at 11:01 pm

    #918762

    viji (11/6/2008)

    Hi,

    How to convert EDI PAD files into SQL Server using SSIS 2005

    any suggestions, links are highly appreciated.

    Thanks,

    Regards,

    Viji

    Check EDI Source component. You have to setup 852 configuration using simple XML configuration file. Contact us if you have questions.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • December 30, 2008 at 1:55 am

    #918854

    Hi,

    Thanks for your replies

    We started taking care of EDI files from VB.NET environment as we couldnot handle it in SSIS.

    Thanks,

    Regards,

    Viji

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply