Stalling/Hanging DTS Package

• Eamonn Dempsey-423042

  Grasshopper

  Points: 12

  More actions

  March 27, 2007 at 7:19 am

  #68099

  I have a DTS Package which runs fine when run from Enterprise Manager, however when run from a command prompt it runs all the way through, completing successfully but does not actually complete - ie it hangs on the line "DTSRun : Package Execution complete."

  The last thing to run is a VB Script which is as follows :

  Function Main()

  Dim RS

  Dim blnFailed

  Dim objEventLog

  Dim fso

  set RS = CreateObject("ADODB.Recordset")

  set RS = DTSGlobalVariables("CheckDateData").value

  set objEventLog = CreateObject("LogEvent.LogNTEvent")

  blnFailed = False

  RS.movefirst

  while not RS.EOF

  If RS.Fields(0) = "0" Then 'Incorrect Date

  blnFailed = True

  End If

  RS.movenext

  wend

  Main = DTSTaskExecResult_Success

  End Function

  I know it gets to the last line as I placed a msgbox there which got displayed when run from the command line. The CheckDateData global variable is an output parameter from a preceeding SQL Task.

  Any ideas? Many thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 739410

  More actions

  March 27, 2007 at 10:35 am

  #697215

  Very strange. Does it hang when scheduled? I'm assuming that's the issue.

  Are you sure there's nothing else in the package that would pop a msgbox or wait for some interactive event?

• Eamonn Dempsey-423042

  Grasshopper

  Points: 12

  More actions

  March 30, 2007 at 1:51 am

  #697811

  I managed to resolve the problem - you need to ensure the "Execute in Main Thread" is set to true