hi,
I have a problem with DataPump in recognizing the row length in a text file.
I have a flat file with varibale row lengths. The first row is around 30
characters ends with null and the next couple of rows with 70 characters ends
with null. The DTS is picking up only 30 characters from all the rows as the
first row is 30 characters, leaving the remaining characters. Entire row
corresponds to one column in one database table.
How to fix the problem?

Thanks in advance,
Sreenath

The problem is that DTS is not very good at handling variable length rows
like this

You could try this article

http://www.databasejournal.com/featu...le.php/1462341

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Sreenath" <Sreenath (AT) discussions (DOT) microsoft.com> wrote