CODEWITHSUNDEEP
c#ssis
NMarshallx86
NMarshallx86

Reputation: 127

SSIS - How to get error messages from Package.Validate()

I wrote a utility that dynamically generates SSIS packages and I am using the Package.Validate() call to make sure they are correct before deploying them to the server. However, when the function fails it just returns DTSExecResult.Failure. Currently in order to view the error messages I need to open the package in Visual Studio.

Is there a way to retrieve those validation errors in code so I can log those errors and not have to take that extra step?

Upvotes: 1

Views: 458

Answers (1)

NMarshallx86
NMarshallx86

Reputation: 127

So apparently you need to create a class that implements the IDTSEvents interface. These methods will fire when the validate() function raises them.

Upvotes: 1

Related Questions