DTS - text file to Sql Server table

#1

Hi there

I import a flat file to SQL Server and it never transfers
the LAST row in the file. I have got the "First row has
column names" checked ... this might have something to do
with it???

I recall having this problem before in the past!

Thanks
Krysia

#2

This may help..

FIX: DTS Fails to Import Last Row If There is No Last Row Termin ID:
Q259304

http://support.microsoft.com/default...EN-US;qQ259304

--
HTH
Ryan Waight, MCDBA, MCSE

"Krysia" <kniekrasz (AT) fairbairncapital (DOT) com> wrote

Quote:

Hi there

I import a flat file to SQL Server and it never transfers
the LAST row in the file. I have got the "First row has
column names" checked ... this might have something to do
with it???

I recall having this problem before in the past!

Thanks
Krysia

#3

I have a few other Kbase's bookmarked that may be relevant :-

Q241761
Q251119

--
HTH
Ryan Waight, MCDBA, MCSE

"Ryan Waight" <Ryan_Waight (AT) nospam (DOT) hotmail.com> wrote

Quote:

This may help..

FIX: DTS Fails to Import Last Row If There is No Last Row Termin ID:
Q259304

http://support.microsoft.com/default...EN-US;qQ259304

--
HTH
Ryan Waight, MCDBA, MCSE

"Krysia" <kniekrasz (AT) fairbairncapital (DOT) com> wrote in message
news:055201c38e66$b3c90550$a001280a (AT) phx (DOT) gbl...
Hi there

I import a flat file to SQL Server and it never transfers
the LAST row in the file. I have got the "First row has
column names" checked ... this might have something to do
with it???

I recall having this problem before in the past!

Thanks
Krysia

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS - text file to Sql Server table

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS - text file to Sql Server table - 10-09-2003 , 08:10 AM

Re: DTS - text file to Sql Server table - 10-09-2003 , 08:14 AM

Re: DTS - text file to Sql Server table - 10-09-2003 , 08:18 AM