"Jennifer Kenney" <jkenney@pembrooke.com> wrote in message
news:uqsvEUATFHA.2680@tk2msftngp13.phx.gbl...
> Hi, I'm Jennifer Kenney, I'm mostly SQL/TSQL, but I'm using DTS for
obvious
> DTS things, and I've got an issue with DTS respecting the Row Delimiters
in
> a text file (source) connection.
>
> The fixed-width text file has a CRLF row delimiter, visible when I read it
> in Word with the view options set to view all, and when I checked to see
if
> I could import it into Excel, it read the CRLF just fine BUT!!!
>
> The individual rows are sometimes shorter than they ought to be; the last
> field in the row isn't always present, and my data pump, instead of seeing
> the Row Delimiter and moving the data down to the next row, is filling
data
> into the trailing field from the next record, then cutting off record 2
> after the 30 chars that field allows and starting the next row with record
> 3.
>
> Any advice?
>
> JBK
>
>

<shumaker@cs.fsu.edu> wrote in message
news:1114716950.450143.264010@o13g2000cwo.googlegroups.com...
>I handle things like this with ActiveX scripts. My preference for text
> manipulations is PERL. If you have ever programmed in C or even C++,
> then PERL isn't to terribly difficult and is well suited for text
> manipulation.
>
> I think you'd want to read the file line by line, each time into a
> local string variable, and check the length of the string, then output
> that string with additional spaces to ensure it is the proper length.
>

"Ilya Margolin" <ilya_no_spam_@unapen.com> wrote in message
news:ue%23Xi2ATFHA.2996@TK2MSFTNGP15.phx.gbl...
> Jennifer,
>
> Then the file is not fixed-width in a strict sense. If you opened the file
> and filled up missing width it would be working.
>
> Ilya
>
> "Jennifer Kenney" <jkenney@pembrooke.com> wrote in message
> news:uqsvEUATFHA.2680@tk2msftngp13.phx.gbl...
>> Hi, I'm Jennifer Kenney, I'm mostly SQL/TSQL, but I'm using DTS for
> obvious
>> DTS things, and I've got an issue with DTS respecting the Row Delimiters
> in
>> a text file (source) connection.
>>
>> The fixed-width text file has a CRLF row delimiter, visible when I read
>> it
>> in Word with the view options set to view all, and when I checked to see
> if
>> I could import it into Excel, it read the CRLF just fine BUT!!!
>>
>> The individual rows are sometimes shorter than they ought to be; the last
>> field in the row isn't always present, and my data pump, instead of
>> seeing
>> the Row Delimiter and moving the data down to the next row, is filling
> data
>> into the trailing field from the next record, then cutting off record 2
>> after the 30 chars that field allows and starting the next row with
>> record
>> 3.
>>
>> Any advice?
>>
>> JBK
>>
>>
>
>

"Jennifer Kenney" <jkenney@pembrooke.com> wrote in message
news:%23fm6wNETFHA.3392@TK2MSFTNGP12.phx.gbl...
>
> <shumaker@cs.fsu.edu> wrote in message
> news:1114716950.450143.264010@o13g2000cwo.googlegroups.com...
> >I handle things like this with ActiveX scripts. My preference for text
> > manipulations is PERL. If you have ever programmed in C or even C++,
> > then PERL isn't to terribly difficult and is well suited for text
> > manipulation.
> >
> > I think you'd want to read the file line by line, each time into a
> > local string variable, and check the length of the string, then output
> > that string with additional spaces to ensure it is the proper length.
> >
> Ugh. So do a connection before the data pump and adjust the text file
> there?
>
>

"Jennifer Kenney" <jkenney@pembrooke.com> wrote in message
news:uqsvEUATFHA.2680@tk2msftngp13.phx.gbl...
> Hi, I'm Jennifer Kenney, I'm mostly SQL/TSQL, but I'm using DTS for
> obvious DTS things, and I've got an issue with DTS respecting the Row
> Delimiters in a text file (source) connection.
>
> The fixed-width text file has a CRLF row delimiter, visible when I read it
> in Word with the view options set to view all, and when I checked to see
> if I could import it into Excel, it read the CRLF just fine BUT!!!
>
> The individual rows are sometimes shorter than they ought to be; the last
> field in the row isn't always present, and my data pump, instead of seeing
> the Row Delimiter and moving the data down to the next row, is filling
> data into the trailing field from the next record, then cutting off record
> 2 after the 30 chars that field allows and starting the next row with
> record 3.
>
> Any advice?
>
> JBK
>