Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Adding a C# import causes SSIS error ? Expand / Collapse
Author
Message
Posted Monday, December 30, 2013 1:26 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 15, 2014 8:51 PM
Points: 183, Visits: 480
In my simple C# script task was getting the error -

Package Validation Error

Error at Send Mail: 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. Error at Send Mail: There were
errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

In my case I was just using a simple try catch block to catch Exception in simple code. I added a using System.Exception;
I got the error after that. I just realized that this import is not needed and is the cause of the error. I don't know why it causes an error in SSIS.

Post #1526598
Posted Monday, December 30, 2013 2:56 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:50 PM
Points: 6,257, Visits: 7,442
blasto_max (12/30/2013)

Error at Send Mail: 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. Error at Send Mail: There were
errors during task validation.


The most common cause of this error is a syntax error where the compiler didn't build the binary for the object. Go in and check it.



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1526621
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse