SSIS INTEGRATION SERVICES EXERCISES▼
- Data flow tasks (4)
- Basic data transforms (1)
- Data conversion transforms (2)
- Conditional split transforms (5)
- Lookup transforms (4)
- Looping over files (3)
- Looping over rows (2)
- Merge joins (1)
- Previous versions (18)
- Script tasks (1)
- Variables in script (1)
- Script components (2)
- Accessing file attributes (2)
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.
You can learn how to do this exercise on the relevant Wise Owl classroom training course (sadly for the moment only in the UK).
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):
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:
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:
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!