locked
Cobol Copybooks RRS feed

All replies

  • I myself have gotten around this issue using the unpack decimal transformation, a pivot / unpivot lookup calculation as described by phil brammer (http://www.ssistalk.com/2007/03/14/ssis-working-with-cobol-zoned-signed-decimals/) for zoned decimals, and then using a single large space with derived column and conditional splits to deal with the redefines and / or variable lengths.  It is a pain and I would suggest talking with your developers who work with the cobol code to determine whether or not it is possible to write some wrapper routines to strip out the redefines, variable lengths, zoned / packed decimals etc and give you a normal flat file.

     

    As an aside there was a recent release from amino software relating to this type of information.  However, it is 3rd party and it costs money.  Please note that I have not had an oppurtunity to use this, and I am in no way shape or form associated with these guys.

     

    http://www.aminosoftware.com/

     

     

     

    Wednesday, July 2, 2008 12:32 PM