Error when package is executed as JOB. (same runs without err while executing from BIDS)

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  August 18, 2009 at 12:22 am

  #138156

  Dear All,

  I created a package for deleting some files from a particular folder. I scheduled a job for executing the same. It's working fine in TEST server. But the same is not working in LIVE server. I am getting the following error.

  "The task "Script Task" cannot run on this edition of Integration Services. It requires a higher level edition. End Error DTExec: The package execution returned DTSER_FAILURE (1)"

  In LIVE server, If open the package in BIDS and execute it works without any problem. But when I schedule it and run as a job it's giving the above mentioned error.

  What could be the problem.? It's very urgent. !

  Thanks in advance.

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  August 18, 2009 at 1:17 am

  #1040647

  Dear All,

  Couldn't find many solution in Google. Went for a toss.

  I solved the issue by reinstalling the Integration Services once again. It worked.

  Thanks.