Issue while executing Script task from SQL Agent Job.

• kothari_ic

  SSC Enthusiast

  Points: 102

  More actions

  February 6, 2012 at 5:35 am

  #251031

  Hi All,

  Even I am getting the same error while using the Script Task and executing it in SQL Agent Job.

  The script task is a basic task to test the scenario.

  String s1 = "FirstName";

  string s2 = "lastName";

  String s3 = s1 + s2;

  If I execute in BIDS, it is running successfully. But while trying to through SQL Server Agent it fails with below error.

  Executed as user: DOMAIN\USER. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 12:52:50 PM Error: 2012-02-06 12:52:51.69 Code: 0xC0012024 Source: Script Task Description: The task "Script Task" cannot run on installed (64-bit) of Integration Services. It requires Standard Edition (64-bit) or higher. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:52:50 PM Finished: 12:52:51 PM Elapsed: 1.313 seconds. The package execution failed. The step failed.

  Any help is much appreciated to resolve this issue.

  Thanks !!

  Swapnil

• February 6, 2012 at 7:12 am

  This was removed by the editor as SPAM

• johnitech.itech

  Hall of Fame

  Points: 3252

  More actions

  February 6, 2012 at 7:47 am

  #1443143

  Show same issue at below link

  http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/625d0475-30e5-4b45-95cc-6f49742569a0