Hi!

I am running SQL 2000 SP4.
I have a table1 with about 6.5mil rows. I created another table
(table2) and I needed to transfer all data from table1 to table2. I
used DTS Import/Export feature however packages keeps running without
any completion in the status it says Started (134000) and it doesn't
go any further.
I would assume that it transferred 133000 rows and is being stuck on
134000's but I don't know how to look for that row.
My table structure as follows:
Col1 (PK, char(50), not null)
Col2 (PI, int, not null)
Col3 (PK, datetime, not null)
Col4 (float, not null)
Only one clustered index defined on all primary keys.
Is there a way for me to determine why the package is hanging on
134000 row and not going any further.
T.

"tolcis" <nytollydba@gmail.com> wrote in message
news:a09a616f-b6ff-4ae5-a9d0-dc3bbe0afa91@p25g2000hsf.googlegroups.com...
> Hi!
>
> I am running SQL 2000 SP4.
> I have a table1 with about 6.5mil rows. I created another table
> (table2) and I needed to transfer all data from table1 to table2. I
> used DTS Import/Export feature however packages keeps running without
> any completion in the status it says Started (134000) and it doesn't
> go any further.
> I would assume that it transferred 133000 rows and is being stuck on
> 134000's but I don't know how to look for that row.
> My table structure as follows:
> Col1 (PK, char(50), not null)
> Col2 (PI, int, not null)
> Col3 (PK, datetime, not null)
> Col4 (float, not null)
> Only one clustered index defined on all primary keys.
> Is there a way for me to determine why the package is hanging on
> 134000 row and not going any further.
> T.
>
>
Hi

If these tables are in the same database or on the same server or on a
linked server you could use INSERT...SELECT instead with two/three or four
part names.

Does the destination table have the same PK?

If you create the table without this does it work?

You could try BCP and do it as a 2 stage process.

John