Please I have one problem yet. I save txt file onto disk, but when I try read this txt file I will get error.

When I try DTS package and bulk insert with row terminator comma and column terminator TAB, i get error Unexpected end of file.

When I try stored procedure and bulk insert :

declare @SQL varchar(8000)

SET @SQL= 'BULK INSERT #WRK FROM ''c:\denni_kurz.txt' + ''' WITH (CODEPAGE = ''1250'' , FIELDTERMINATOR = ''|'',ROWTERMINATOR ='''') '

CREATE TABLE #WRK (TEXT_STRING text)

EXEC(@SQL)

SELECT * FROM #WRK

I get only first few rows, but not all.

When I try vb.net project with StreamReader, then I read all text.

Where is the problem ?

I don't see anything wrong in this text.

Thanks for help.