Post reply

DTS Problem with Text File Line Length

  • May 28, 2008 at 4:46 pm

    #121628

    I'm working on a process to import a text file, and I have to admit that my DTS Fu is not strong. The text file contains a header record, the rest of the file are detail records. They do not have the same format. So I create two text file definitions feeding two transform data tasks going to the two tables. The header record parses fine, but the detail records do not: they're some 260 bytes and DTS seems to want to truncate the records at column 80 and that's it. It doesn't make sense to me, but perhaps I am of but little brain today.

    I'm not having any luck with BCP or Bulk Insert, though I'm going to continue plugging away at them.

    Any suggestions?

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • May 28, 2008 at 4:58 pm

    #821507

    Answered my own question!

    There's a box that lets you skip X number of rows. When I told it to skip the first row, then it allowed me to define columns beyond 80.

    *sigh* I guess if it were easy, we wouldn't be able to command our princely salaries (in a parallel dimension very much like our own).

    :hehe:

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

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

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