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.
Regards
Jorge




Reply With Quote