I am using Text File(Source) object to read the data from a flat file. Is
there any file size limit to read the data from an ASCII file? I am trying
to read the data from 700+ MB file and when the file format is fixed field,
I am not seeing the data in the editor to map.

I am presuming that this is because of source file size.

I am using SQL2K.

1. Is there any source file size limit to read the data as mentioned above?

2. Any other reason that I cannot see data when I am in the data mapping
steps.

Thanks,

Hill

The "Source Viewer" only shows the first 200 lines of data. The file should
be all of the same structure so this should be enough. Have you tried
importing the file yet?

--



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


"John Hilton" <John_Hilton2004 (AT) hotmail (DOT) com> wrote

Now I am getting the following error message.
"Could not find the selected row delimiter within the first 8 KB of data. Is
the selected row delimiter valid?"
What is the meaning of this message?
Thanks,
Hilton



"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

It means that DTS has run through the first 8KB of data in the file (why
8K? - it is the page size in SQL Server and a row cannot span > 1 page). It
is saying that the row terminator you chose in the setup of the file cannot
be found in that amount of data.

--



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


"John Hilton" <John_Hilton2004 (AT) hotmail (DOT) com> wrote

A very reasonable answer. What you are saying is 8kb limit cannot be
changed.

Thank you so much.

Hilton


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote