I have a Pipe delimited flat file which has 10 columns.The last column will by default have no value.
The DTS Package recognises only 9 columns. Is that a bug with the DTS or is the row delimiter not defined correctly.
Note
If a dummy value is given in the last column then all the 10 columns are recognised.

What does the row in the text file look like. I do not have 2000 with me to
check I only have Yukon at the moment.

I created a text file that looks like this

A|B|C|D|E|F|G|H|I|
A|B|C|D|E|F|G|H|I|J

It correctly interpreted my needs for 10 attributes.



--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

I shall give you the actual text it is 58 columns and the 58th column is what is giving the proble

2003-11-04 15:26:51|15256|13325|"EFAC"|"U"|"Cruz, Wanda"|15256|"LAS VEGAS"|"LAS VEGAS"|"LAS VEGAS"||""|""|0||||""||"RAMSHEAD"|"7800 W. ANN ROAD"|""|"LAS VEGAS"|"NV"|"89129"|"CLARK"|"JAMAL ETAHIRI"|"OMC TSS"|"2063895020"|"8008326662"|"1078248"|""|"36.26 41667"|"-115.2655556"|"7"|"LEXINGTON FAYETTE COUNTY POLICE"|"150 E MAIN"|"LEXINGTON"|"KY"|"40507"|"8592583600"|"LEXIN GTON FIRE DEPT"|"219 E 3RD"|"LEXINGTON"|"KY"|"40507"|"8592241120"|"CN0174 29"|""|2001-10-02 00:00:00|3|2|||""||""


----- Allan Mitchell wrote: ----

What does the row in the text file look like. I do not have 2000 with me t
check I only have Yukon at the moment

I created a text file that looks like thi

A|B|C|D|E|F|G|H|I
A|B|C|D|E|F|G|H|I|

It correctly interpreted my needs for 10 attributes



--

Allan Mitchell (Microsoft SQL Server MVP
MCSE,MCDB
www.SQLDTS.co
I support PASS - the definitive, global communit
for SQL Server professionals - http://www.sqlpass.or


"Arun" <anonymous (AT) discussions (DOT) microsoft.com> wrote in messag
news:30772AEC-7416-47D0-A099-0B1618DD34CF (AT) microsoft (DOT) com..

As mentioned earlier I only have Yukon here but it works with your example

{CR}{LF} = Row Delim

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

ROAD"|""|"LAS VEGAS"|"NV"|"89129"|"CLARK"|"JAMAL ETAHIRI"|"OMC
TSS"|"2063895020"|"8008326662"|"1078248"|""|"36.26 41667"|"-115.2655556"|"7"|
"LEXINGTON FAYETTE COUNTY POLICE"|"150 E
MAIN"|"LEXINGTON"|"KY"|"40507"|"8592583600"|"LEXIN GTON FIRE DEPT"|"219 E
3RD"|"LEXINGTON"|"KY"|"40507"|"8592241120"|"CN0174 29"|""|2001-10-02
00:00:00|3|2|||""||""|