Executing a DTS Package

• Yasir Masood

  SSChasing Mays

  Points: 601

  More actions

  January 9, 2009 at 9:32 am

  #71130

  Hello,

  I am trying to run a DTS Package from a stored procedure. But when I execute the procedure

  from the Query Analyzer, the procedure never completes. Here is the code for executing the

  DTS package.

  --create a package object

  EXEC @hr = sp_OACreate 'DTS.Package', @object OUTPUT

  if @hr <> 0

  BEGIN

  print 'error create DTS.Package'

  RETURN

  END

  EXEC @hr = sp_OAMethod @object, 'LoadFromSQLServer("myDB","","",256,,,, "OVCF")',

  NULL

  IF @hr <> 0

  BEGIN

  print 'error LoadFromStorageFile'

  RETURN

  END

  EXEC @hr = sp_OAMethod @object, 'Execute'

  IF @hr <> 0

  BEGIN

  print 'Execute failed'

  RETURN

  END

  If I comment out the last part (Execute of the object), the procedure runs fine. I need your help

  in figuring out what I need to do.

  Thanks

• Yasir Masood

  SSChasing Mays

  Points: 601

  More actions

  January 14, 2009 at 8:33 am

  #926608

  I still need help. Please.