User friendly SSIS errors

Question

Post reply

User friendly SSIS errors

pramod chavan

Valued Member

Points: 55
More actions
July 29, 2010 at 11:30 am

#148277

Default SSIS errors are junky and more technical for an end user. I have simple package which loads data from csv file into sql tables but when there is a any error it gives too many details. I would like to customize the errors in such a way that it simply shows row no., column name and type of error (conversion/blank field.).
Any suggestion?

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 1

Hi Pramod,

You might want to create a a set of Event Handlers.

You may use the Script Task to suit your need.

As a best practice it is adviced to use a Event Handlers

Raunak J

RonKyle SSC-Dedicated Points: 31574 More actions · Answer 2

I agree that the error handling is very clunky in SSIS, but as for the suggestion to script event handlers, would you please provide more details? thanks,

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 3

In BIDS, you have a tab Event Handlers. In the Executables dropdown, you can choose to which task you want to add an event handler. In the Event Handler dropdown, you can choose the type of event handler. Usually this is OnError.

Basically, the following happens: when an error occurs for a specific task, the event handler for that task will be called. In the event handler, you can define tasks that should be executed when an error occurs.

So, you can place a script task in your event handler (or an Execute SQL Task) and that way you can create custom logging.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 4

OnTaskFailed or OnWarning and many other events are availble and might be used as and when need arises.

Raunak J

RonKyle SSC-Dedicated Points: 31574 More actions · Answer 5

I would have preferred a more extensive answer. Could you provide a sample of how you would do what you are suggesting?

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 6

Ron it's easier to understand. I believe you should try one yourself.

For example: Provide an incorrect connection string and catch/handle the error.

Raunak J

RonKyle SSC-Dedicated Points: 31574 More actions · Answer 7

I have tried, otherwise I wouldn't ask. For all I have accomplished in SSIS, which is a lot, I have not been able to make it return useful error messages. I often have to set break points and experiment, which isn't very efficient.

As you have said that it can be done, I'd like to know how.