SSIS Integration Services | Previous versions exercise | Use an OnError event-handler to show errors in script y

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Software ==> SSIS Integration Services  (46 exercises)
Version ==> SSIS 2012 and later
Topic ==> Previous versions  (18 exercises)
Level ==> Average difficulty
Subject ==> SSIS training
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Create a package to import data from the Excel workbook in the above folder (you may be able to amend a package you've created earlier):

Importing bushtucker data

A data conversion task to attempt to convert the item id into an integer.

This package will fail when you run it, because the item numbers shown below can't be converted to integers:

Unconverted yellow cells

The yellow cells can't be converted to integers.


Attach an event-handler to the OnError event of the data conversion task so that it displays the description of the error.

You'll need to pass the ErrorDescription system variable into the script task for the event-handler.

Rerun your package: you should now see an error message on screen looking something like this:

Error message

Here we've added a title and some introductory text to the error message.

If you're feeling energetic, you could always try using a ReadWrite integer variable to track the number of errors, to ensure you only display a dialog box like the one above for the first error.

When you've got this working, close this package down!

This page has 0 threads Add post