increasing DTS Package Execution time

• Sharad Rastogi

  SSC Rookie

  Points: 27

  More actions

  May 22, 2006 at 10:38 pm

  #76531

  I am Executing a .ASPX page using MSXML2.ServerXMLHTTP object it takes a long time to execute and after 30 seconds DTS Package stops execution with script time out error. Please help me regarding this if any of you have any idea.

   

  Thanks

   

  sharad rastogi

  sharadr@sebiz.net

• mike gercevich

  SSCrazy

  Points: 2961

  More actions

  May 24, 2006 at 7:27 am

  #639764

  Three things to check.

  1) IIS Script Execution Timeout.

  2) SQL Server connection timeout.

  3) depending on how your are initiating the execution on the package, SQL Command execution timeout.

  For longer running packages, look into using the Job Scheduler and execute the package asynchronously.

  -Mike Gercevich