I need a little help in SQL 2000 Server 
Author Message
 I need a little help in SQL 2000 Server

Hi there,

I wonder if anyone could help me in a subject relationated with sql
server 2000. I'm trying to import a text file with the tool
"import/export" but when it comes the last part of the all process it
gives the following error: "error at source for row number 15907 too
many columns found in the currente row; non white-space characters
were found after the last defined columns's data".

I've already look at microsoft tech and found this document:
http://www.***.com/ ;en-us;301060

In this document says to workaround doing the following:
1. use the bulk copy program(bcp) or bulk insert statement to import
the data into a SQL Server table
2. use the microsoft text driver to specify the source text file
3. make either of the following motifications to the text to cause the
import winzard complete successfully:
        3.1. add or delete a character in any row or column of the
text file
        3.2 add or delete a row anwhere between row 1 and row (which
give the error) in the text file

What do you advice?... I've already try to follow this points above
but without success... :(

In this all process I've got a script that is already made in vbscript
that gets the todays file.
i.e. Today is Sunday, so the script will get the following file:
"20030525.log"

So the process that I'm trying to do must be an automatic proccess to
get today's file.

I hope someone could help me on this subject.

Thanks
Best Regards
Nuno



Thu, 10 Nov 2005 22:06:13 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. I need a little help in sql 2000 server

2. Need Connection string for VB6 DAO DSN-LESS Connections to SQL Server 2000

3. Need Connection string for VB6 DAO DSN-LESS Connections to SQL Server 2000

4. DNS less Access Linked tables to SQL Server 2000

5. SQL Profiler 2000 - A little help please

6. Need Help with Work around: Updatable Recordset on Access Form , sql server 2000

7. i need help viewing relational tables in sql server 2000

8. Need help with SQL Server 2000 - user defined functions

9. Need help SQL 2000 Linked Server with AS400

10. Newbie to SQL Server 2000 needs help

11. SQL Server 2000 Mail setup help needed.

12. I need a help regarding completely database backup in SQL Server 2000


 
Powered by phpBB® Forum Software