Hi All. Could anyone resolve my issue. I was created a package with an Script task written in VB.Net. The Package was executing Successfully in BIDS. But when i tried to exceute the same using Sql server Agent Job, Its getting Failed with the below error message "Executed as user: Admin. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 5:12:27 PM Error: 2013-03-13 17:12:32.33 Code: 0x00000005 Source: Checking Alcon Files Checking Alcon Files Description: Failed to compiled scripts contained in the package. Open the package in SSIS Designer and resolve the compilation errors. End Error Error: 2013-03-13 17:12:32.33 Code: 0x00000005 Source: Checking Alcon Files Checking Alcon Files Description: BC30179 - enum 'ScriptResults' and enum 'ScriptResults' conflict in class 'ScriptMain'., ScriptMain.vb, 156, 22 End Error Error: 2013-03-13 17:12:32.36 Code: 0x00000005 Source: Checking Alcon Files Checking Alcon Files Description: The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully. End Error Error: 2013-03-13 17:12:34.28 Code: 0x00000005 Source: Formating Excel Sheet Formating Excel Sheet Description: Failed to compiled scripts contained in the package. Open the package in SSIS Designer and resolve the compilation errors. End Error Error: 2013-03-13 17:12:34.28 Code: 0x00000005 Source: Formating Excel Sheet Formating Excel Sheet Description: BC30179 - enum 'ScriptResults' and enum 'ScriptResults' conflict in class 'ScriptMain'., ScriptMain.vb, 191, 22 End Error Error: 2013-03-13 17:12:34.29 Code: 0x00000005 Source: Formating Excel Sheet Formating Excel Sheet Description: The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully. End Error Error: 2013-03-13 17:12:51.56 Code: 0x00000004 Source: Checking Alcon Files Description: The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully. End Error Error: 2013-03-13 17:12:51.56 Code: 0xC0024107 Source: Checking Alcon Files Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 5:12:27 PM Finished: 5:12:51 PM Elapsed: 24.336 seconds. The package execution failed. The step failed." Please give some solution to this. Thanks in advance

This is saying that the script could not be compiled. Open the sript editor and look for errors in your code. David Dye My Blog