Bulk Copy Failed?

[nowayout]

I don't know why the bulk copy failed? i am trying to do dts between two database on same server. any suggestion.

Thanks

 

[SQLBill]

What error(s) did you get?
How many rows are you trying to DTS?
Are the columns the same in both databases?
-Are the names of the columns the same in each
-Are the matching columns of the same datatype
-Are the matching columns the same length
(VARCHAR(5) and VARCHAR(5)
not VARCHAR(10) and VARCHAR(5))

We are going to need more information than what you provided.

-SQLBill

 

[nowayout]

i am trying to DTS all the table from table from one database to other database but i get error while dts to other database it takes about 2 to 3 hours to tranfer so i let it runovernight, but in morning i see the error that it fails, and when i double click on it it says the SQLDMO bulk copy is failed.
any suggestion?
thanks

 

[esdee]

not much info in your post.
have dts to log execution result to a file; that should give a little more info on the error

 

[nhtechgal]

Hi,

I'm having the same problem. I'm trying to restore some records from a backup of the table. They reside on the same server. There are approx. 1000 records I'm trying to DTS and the structures should be identical. I'm getting just a "SQL-DMO bulk copy execution failed" message when trying to copy the object.

I have also tried copying the table and get a different message - "Error at destination for row #35. [DBNETLIB][ConnectionWrite(Send()). General network error."

I have also tried a variety of workarounds - importing it in pieces by query (very ineffecient, but seems to work, but I'm getting desperate!). The strange thing is that the line number for the above message seems to move - sometimes it seems "random", sometimes it is reliably the "last" row (e.g., if I write the query for the first 100 lines, it errors out on line 100; if I shrink it to 50, it errors out on 50). Sometimes it works fine.

I have even tried exporting to text/Excel/Access and reimporting with no luck.

Any ideas?

Thanks!

 

[SQLBill]

Is your connection timing out and closing on you? Is anything else going on that could be 'kicking' your transfer out?

-SQLBill

 

[collierd]

Have you installed the latest service pack
I had a similar problem going back some time
There was nothing wrong with the underlying data or the method I was using, it was a bug in SQL 2000
Upgarding to SP2 fixed it (think we are up to SP3 now)

Damian.

 

[nowayout]

i have sp3 on my server

 

[collierd]

Is memory an issue?

 

[nhtechgal]

Hi,

Me again. I just checked SQL Server version is 8.00.760.0 which should be SP3. Connection does not appear to be timing out best as I can tell (I have previously gotten timeout errors). I haven't had problems with longer PCAnywhere and other connections to/from the same PCs.

Hmmm...Could it be a memory issue? Some of these files are TINY (few hundred records, few dozen K at most), so I'd be surprised. Other ideas?

Thanks for checking!