Figure 1.10 Transform Path Defined.
Figure 1.10 shows that we now have a transformation defined between the text file and the SQl Server connection.
You can tell the direction of the dataflow by the way the arrow is pointing. Double click on the black line.
Figure 1.11 Set Source.
Here we need to set what we want to transfer to SQL Server. Normally we would be able to move a subset of the data by defining the Source
as an SQL statement. The Text File provider does not allow us to do this so we have to make do with taking all the data across. The only option
on this screen that we are able to choose is to preview the data.