DTS runs manually but not from schedule

• jonatanalvarez77

  Grasshopper

  Points: 21

  More actions

  August 11, 2009 at 7:55 am

  #385158

  Hello Everyone,

  I have a DTS package that receives certain parameters.

  If a run it manually from whitin the package designer, setting those parameters manually, it runs ok.

  But when I use the DTSRUN command to schedule it in the agent as a job it doesn't. The same command line I'm using in the job works fine if I run it in a CMD window.

  Any ideas?

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  August 12, 2009 at 11:09 pm

  #1038459

  What is the error?

  Also it is probably a permissions issue, does the account that SQL Agent runs under have permissions on the objects being manipulated?

  CEWII