Hello,

Inicialy i had created a job to transfer all objects between 2 servers (that
failed) , then i created 2 new jobs one that transfer all stored procedures
(that's work) and another to transfer all tables (that's fails)

I get the following error :

Executed as user: ARES\SYSTEM. ...n OnStart: Copy Data from acessos to
[dinefer].[dbo].[acessos] Step DTSRun OnStart: Copy Data from
acessos_por_grupo to [dinefer].[dbo].[acessos_por_grupo] Step DTSRun
OnStart: Copy Data from acessos2 to [dinefer].[dbo].[acessos2] Step DTSRun
OnStart: Copy Data from actividades to [dinefer].[dbo].[actividades] Step
DTSRun OnProgress: Copy Data from acessos2 to [dinefer].[dbo].[acessos2]
Step; 1000 Rows have been transformed or copied.; PercentComplete = 0;
ProgressCount = 1000 DTSRun OnProgress: Copy Data from acessos2 to
[dinefer].[dbo].[acessos2] Step; 2000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: Copy Data
from acessos_por_grupo to [dinefer].[dbo].[acessos_por_grupo] Step; 255 Rows
have been transformed or copied.; PercentComplete = 0; ProgressCount = 255
DTSRun OnFinish: Copy Data from acessos_por_grupo to
[dinefer].[dbo].[acessos_por_grupo] Step ... Process Exit Code 60. The step
failed.

Any suggestion of what's might be causing the failure, thanks.

Kind Regards
Jorge Cavalheiro

Have you looked at the DTS log file rather than the job log file? This will
give you better/clearer information on where it's failing.
Where the error file is and what it's called is specified in DTS Package
Properties under the Logging tab

"Jorge" wrote:

Hello Paula
I looked at the log file and found several errors similar to one below :

Error: -2147467259 (80004005); Provider Error: 2627 (A43)

Error string: Violation of PRIMARY KEY constraint
'PK_actividades_pro_1__55'. Cannot insert duplicate key in object
'actividades_pro'.

Error source: Microsoft OLE DB Provider for SQL Server

Help file:



Help context: 0


Shouldn't the dts recreate the tables on destination and then copy all the
rows?

Regards
Jorge

"PaulaPompey" wrote:

Sounds like your DTS is not recreating the tables. Make sure you have set
it up to drop existing tables if they already exist before trying to create
them. Alternatively, truncate the tables before inserting data - this will
clear all data and reset any autoidentity fields. The error you are getting
indicates that the primary key contraints are stopping the insert, ie it is
trying to insert a duplicate value where no duplicates are allowed.

"Jorge" wrote: