when scheduling DTS it fails to invoke objshell command

• ksriram_leo

  SSC Rookie

  Points: 25

  More actions

  April 30, 2008 at 9:29 am

  #185027

  Hi,

  This is my code which tries to invoke the objshell command to execute ftp.

  Set objShell = CreateObject("WScript.Shell")

  objShell.Run ("ftp -i -s:" & Chr(34) & strFTPScriptFileName & Chr(34))

  Set objShell = Nothing

  When I run it manually then it runs fine. But when it is scheduled in the sql server then ftp doesnt happen and interestingly there is no error provided.

  Could you provide some solution to this?

  Sri

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  April 30, 2008 at 8:17 pm

  #809414

  Check security;

  Check Job Type in each step;

  Check log output file if there is any. If there is not, create one, which will provide detail information.