ALL SOFTWARE EXERCISES
- EXERCISES HOME PAGE (827)
- Access 2010 (66)
- Access VBA Macros (17)
- Advanced VBA (29)
- Excel 2010 (83)
- Excel 2013 (10)
- Excel 2016 (0)
- Excel VBA Macros (37)
- Power BI - Excel 2013 (25)
- Power BI - Excel 2016 (23)
- Power BI Desktop (26)
- PowerPivot 2010 (26)
- Report Builder 3.0 (42)
- SQL (156)
- SSAS - multidimensional (21)
- SSAS - tabular (29)
- SSIS Integration Services (40)
- SSRS 2016 (14)
- SSRS Reporting Services (53)
- Visual Basic (45)
- Visual C Sharp (65)
- WPF - Visual C# (20)
SSIS INTEGRATION SERVICES EXERCISES
Exercise: Use data conversions to import flat file data to Excel
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.
The answer to the exercise will be included and explained if you attend the relevant Wise Owl course (sadly, only in the UK for now).
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.
Open the text file in the above folder, and you'll see that it contains 20 people from the Sunday Times Rich List 2012 (can you spot the ringers?), with some errors:
Three of the records don't have any value filled in for the person's wealth in millions.
Your task is to import this data into the emptyish Excel workbook in the above folder:
The start of what the results should look like.
Whether you want to use the help overleaf is up to you!
Here's a suggested data flow for this task:
Be careful to test if LEN(Millions) equals 0, rather than whether ISNULL(Millions) equals true, since the millions column will be imported as an empty string, not a null.
Check your import worked. Again, this doesn't claim to be the quickest method to solve this problem!