Post reply

Cant enter ASCII Output FILE Column Length

  • August 19, 2004 at 10:51 am

    #181494

    I am building a DTS package that will input some columns and output derived columns into an Ascii file using a DATA PUMP ACTIVX transformation.

    I need to modify the column lengths in the ascii file as they have defaulted to the lengths of some of the input.  THe column length is protected.  I also don't see any way to add new columns as I would have expected where I could enter the name and length.

    What am I doing wrong??

  • August 19, 2004 at 12:43 pm

    #519865

    I don't think you are doing anything wrong.  It seems DTS will not allow you to change the lengths or add columns other than what is in the source.  You could pump your source into a table that you create with the columns and lengths that you want and then pump that table to the ascii file.

     

    Hope this helps.

  • August 19, 2004 at 12:46 pm

    #519867

    I found that I could modify the lengths with a Dynamic properties task.

    Thanks

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

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