Import Data Status  
Author Message
LRF63





PostPosted: Wed Nov 15 01:57:07 CST 2006 Top

SQL Server >> Import Data Status

Dear all,

I need to copy data from one DB to another DB using the Import Data
function. When I started the transfer, it ran for a certain period then
stopped at around 50% of progress for few hours. The status shown in the
dialog is 608, another case is showing 703. What is the meaning of the
statuses? How can I get reference information about the statuses?

Thanks for any help!

Tedmond

SQL Server116  
 
 
Uri





PostPosted: Wed Nov 15 01:57:07 CST 2006 Top

SQL Server >> Import Data Status Tedmond

I have no idea about these statuses . Consider using T-SQL to copy the data
between the databases

INSERT INTO db1.dbo.Table1 (col1,col2.....) SELECT col1,col2..... FROM
db2.dbo.Table2






> Dear all,
>
> I need to copy data from one DB to another DB using the Import Data
> function. When I started the transfer, it ran for a certain period then
> stopped at around 50% of progress for few hours. The status shown in the
> dialog is 608, another case is showing 703. What is the meaning of the
> statuses? How can I get reference information about the statuses?
>
> Thanks for any help!
>
> Tedmond
>