Post reply

How to generate ASCII Fixed Length file

  • September 24, 2007 at 8:06 am

    #735617

    Guys,

    I just realized it's all a bit overkill.

    The core of the porcess is BCP command.

    Why I'm struggling to execute it from DTS?

    Command Line works fine.

    And if I still have issues with Fixed-Length otput file and its Column Positions

    then I'll use a temp table with controlled lengths (char 28,e.g.)

    Cheers,

    Robert

  • July 24, 2008 at 4:28 am

    #847616

    I have almost the same problem. In my case, all my results were turned into one big string, instead of the 800 rows I expected. I tried to use SQL instead of a full copy, but the results are the same.

Viewing 2 posts - 31 through 31 (of 31 total)

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