Figure 1.9 Define Column Mappings And Transformations

On this screen we have a few choices to make. The button to create a new table is selected already. By default SQL Server assigns to our new table the exact same names as the columns in the text file with a character type of varchar and a length of 8000. This simply means that we would if we left it like this be able to fit character data into the column with a variable length but in no event exceeding 8000 characters. You have two choices with this. You can accept it, which is usually unsatisfactory or you can edit the table creation. Either does this using the Edit SQL button or do it by using the table underneath. As you can see we've chosen to use the table and defined the first column as an integer and modified the length of the rest to 50.

Click on the Transformations tab