Getting an error ''Timeout expired''

• madhavi guthula

  SSC Veteran

  Points: 254

  More actions

  May 24, 2006 at 12:23 am

  #94246

  Hi

  I am executing a DTS package of SQL server through a batch file at command promt.

  we are including 12 DTS packages in a single package which runs through batch file. if we execute the packages individually, they are executing sucuccessfully. But while executing  integrated package some packages gets executing fine and in middle getting an error messge "Timeout expired".

  The following is the exact error message we r getting.  

  Step Error Source: Microsoft Data Transformation Services (DTS) Package

  Step Error Description:Error Code: 0

  Error Source= Microsoft OLE DB Provider for SQL Server

  Error Description: Timeout expired

  So please let me know what is the problem in this and how can i solve it.

   

• barsuk

  SSChampion

  Points: 12280

  More actions

  May 25, 2006 at 3:59 pm

  #640195

  Did you try running trace while this package is executing?