Problem with SQL Server 2000 DTS Package:Column Delimiter not found

I am trying to import data from a text file to SQL database through a DTS package. i am always getting "Column Delmimeter not found" error at record number 8000. i copied the 8000th record into the beginning of the file to test if there is any problem with data but still i got the error at 8000 th record. i know it was a problem before and was fixed with sp1. i installed SP4 and still gettting the same error.

any help on this is appreciated.

Thanks
Venki

Found the actual problem. The error record number that DTS shows is not accurate. Acutal error was at 8790 th record but the DTS shows that the error is at 8000. The data has Quotes in it which was causing the problem.

Thanks
Venki|||

Hi

I'm having the exact same problem, with sp4 installed, and i can't find a solution

did u find a way to solve that problem?

Problem with SQL Server 2000 DTS Package:Column Delimiter not found

I am trying to import data from a text file to SQL database through a DTS package. i am always getting "Column Delmimeter not found" error at record number 8000. i copied the 8000th record into the beginning of the file to test if there is any problem with data but still i got the error at 8000 th record. i know it was a problem before and was fixed with sp1. i installed SP4 and still gettting the same error.

any help on this is appreciated.

Thanks
Venki

Found the actual problem. The error record number that DTS shows is not accurate. Acutal error was at 8790 th record but the DTS shows that the error is at 8000. The data has Quotes in it which was causing the problem.

Thanks
Venki|||

Hi

I'm having the exact same problem, with sp4 installed, and i can't find a solution

did u find a way to solve that problem?

Problem with SQL server - Excel

Hi to all! I am working with SQL server 2000 and up until today, I used to import data in the Server using an Excel Spreadsheet, and the wizard. Last time today, that I tried to do that, I got the following message:

" The instruction at "0x02e21b80" referenced memory at "0x02e21b80". The memory could not be "read".

Any help, would be much appreciated! I am stuck here, and the most akward thing, is that up until today, I kept on importing data from Excel, with the same process with no problem...

Anyway, I thank everyone in advance, just for taking the time to read this thread! :DThe error you describe is a very common error that really is saying "something went wrong and I don't have a clue what to do about it". It probably won't fix if you try again, and it will probably not work if you try to restart your computer (but it might, it has happened to me). I'm assuming that this problem is related to your workstation in some way, removed dll's, uninstalled program that messed up something you needed or something similar.
To rule out possibilities, I would try to do the same thing from another computer. If that works, I'd try to reinstall Excel, and if it didn't work, I'd check out the access privileges the account uses that makes the database connection. Just some tips ... ;)|||Thanks a lot! I'll try doing these things and see what happens!

You' ve offered great help to me, cause I'm in a state of confusion at the moment and I wasn't able to think clearly!

Thanks! :)

Problem with ROWTERMINATOR

I am trying to import data from the text file using BULK INSERT command.

BULK INSERT test.s1_test

FROM 'D:\s1.txt'

WITH

(

CODEPAGE = 1250,

FIELDTERMINATOR = '|',

FIRSTROW = 2,

ROWTERMINATOR = '|\r\n'

)

In the text file in the end of each row is symbol which looks like a square - you can see it here

If I use rowterminator '|\n' of '|\r\n', 0 row(s) affected.

Please, can you help me?

hi,

are you sure it's a CR + LF carachter?

it this is the case, data should show it, but your pic does not..

open it with a hex editor...

regards