One extremely nice thing about the Raw File Destination is that the order of the columns in it don’t matter. Whether you add a column now or in six months it’s position in the raw data file doesn’t matter. Or if you forget to add a column that data source expects and it is setup for the source as the first column.
Execute the package and you will have a Raw File created.
RAW FILE FORMAT SOURCE
Now that we have a file to work with, let’s create a quick package that can import some data from a raw file. As before, we’ll skip going through adding the Data Flow and then Raw File Source and Row Sampling task. The Row Sampling task is just there to provide a place to add a data viewer if you desire to see the data that is returned.