DTS Hangs When Source Database goes down

• Ansari Mohamed Asif

  SSC Veteran

  Points: 276

  More actions

  October 1, 2005 at 12:49 am

  #67052

  Hello Colleagues,

  I have a DTS pacakge in SQL sevre 2K which establishes the connection with Ingres database on different server and copies the data from source table to destination.

  Sometimes when DTS is executing and copying the data, then if source database in Ingres goes down the DTS package goes into a hanging stage without giving any error.

  Any help please.

  Thanks in advance.

  Regards, Asif

• Deni Kusdeni

  Default port

  Points: 1457

  More actions

  October 1, 2005 at 1:06 am

  #594433

  Try to captured on failure in your DTS Package