SSIS PACKAGE SHOWING CONNECTION ERROR BUT THE TASK IS SUCESSFULLY GETTING COMPLETED

• super48

  SSCrazy

  Points: 2682

  More actions

  February 25, 2014 at 10:47 pm

  #288651

  Hi Actually I am Moving data from One server1 To Another Server2

  I create a package and it is running correctly moving data to source to destination

  but in between that

  it showing connection error object or elemnet not their connection failed

  for many times

  Though it is not problem i just want to know why the error messages are coming while executing package though the package executed as per my requirement?

• Sushil Dwivedi

  SSC Eights!

  Points: 973

  More actions

  February 25, 2014 at 11:37 pm

  #1692136

  It could because of database object discrepancies like table schema is different.

• Sushil Dwivedi

  SSC Eights!

  Points: 973

  More actions

  February 25, 2014 at 11:46 pm

  #1692137

  or if any other process is running which doing operation on same objects which data you are trying to move to different server

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  February 26, 2014 at 1:08 am

  #1692150

  It might be helpful if you posted the actual errors.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP