Thanks a lot I will check the thread.

someone dropped the table or table is spelt differently or user account do not have permission on that table.

Where can I see the error log? I can see the activity log from which I pasted the log... The DTS has not logged the history anywhere for now. Thanks...

I think I got it.... I was seeing the select with nolock and that was still not committed. Once the databse was out of space the insert into rolledback and...

Say if we run updates in batches

and if we use

set xact_abort on --...

Top rows is not good for 2000.

http://69.10.233.10/KB/aspnet/BatchUpdate.aspx

this works!

balbirsinghsodhi (3/25/2008)

---

I am trying to delete records in a batch and it's taking forever. there are 65 million rows in one table and I am deleting based on some condition...

thanks a lot this is what i was thining about. Thanks!

Since I cannot use the above BCP command in that server. What do you suggest? Should move the table to another server and do that or should I export using...

Found the problem.... the problem was with the ODBC driver. I have to move this table to dev server and do that that export. I have a table with like...

Thanks!

create a template csv file in a location, use that template for exporting purpose and then archive or change the name of the csv file as per need.

dataType is char(1) and the values can be a-z, 0, 1, blank, nulls. Thanks.

Thanks for the response... this table is pretty busy but can afford to run the query for couple of hours... I need to do this as a one time job...