May 28, 2008 at 4:46 pm
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
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