MentorName and ContestantName had to be set to string data types to match SQL server tables.Īnd finally a preview confirms the column names align well with the data from contestants.txt. SeriesNumber had to be created as an unsigned four-byte integer. In the advanced section changes to the column properties needed to be made(created) because the column names weren’t provided in the CSV file. Since the column names are not included in the CSV file I had to make sure “column names in the first data row was unchecked”. Second step is to create the flat file source, being the contestants.txt. Next step was to create an SQL task that truncated the tables before the task of importing the dodgy flat file was performed. This is the flat source CSV file used, some data is missing on purpose. In this exercise I learned how to filter bad data from a flat file source with the aid of script components.Ĭreating the two tables to export data to was the first step.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |