Bulk insert error

Hi,

I am using bulk insert to insert a lot of information from file to memory. In many cases it do the work but in one place it gives me the exception.

My code:

BULK INSERT tblCompVSNet1 FROM 'E:\EasySeries\WindowsApplication1\bin\Debug\tblCompVSNet1.tbl' WITH ( FIELDTERMINATOR = '|',ROWTERMINATOR = '|',LASTROW = 0,ROWS_PER_BATCH = 10000,CODEPAGE = 'RAW',TABLOCK)

The error:

Invalid object name 'tblCompVSNet1'

The table exists and the query works fine in query analyzer but in code through OLEDB it doesn't work sometimes.

How can I solve my problem?

Thank's
Alexei

how about using bcp instead|||

if you are using sql 2005 and ado.net version 2. you may make use of the BULKCOPYCLASS works almost as fast as DTS

http://oubliette.dnsalias.net/DottextWeb/category/22.aspx/rss

|||

Hi,

I am using the sql 2000 (and msde). Also I am working with .Net 1.1. This is what my clients have.

|||

Hi,

I have 2 problems:

1. I can't use bcp becouse I don't know where the bcp is.

2. When I use. It doesn't work and give the same error.

Thank's
Alexei

|||

Hi,

I have found the solution: my connection string was wrong. It connected to another DB. I had need to specify the DB.

Thank's
Alexei