This Simple Series post will explain how to import a file (.csv,.pdf,.doc, etc.) into the SSIS stream for later consumption. In the package I pulled this from, the end result will be storage of the file as a BLOB in a table for later retrieval by a web front end.
The image below shows the first step in the component, the Input Columns tab, which is to provide the actual file name, path and all of the file you are looking to import. I happen to insert this in the upstream, so at this point FileLocation contains something like '//remotepath/directory/myfile.pdf'.
The next thing that needs to be done is to create a name for the BLOB so SSIS can reference it. Simply click on the Output Columns folder and then click on the Add Column button. Choose a name for the BLOB, I chose FileData, which can now be referenced downstream in the package. Once you create this you will need to copy down the LineageID (as shown in the image). This will be referenced by the Import Column.
What do I do with the LineageID I just copied? Next tab, Input and Output Properties, is where it gets a little tricky. Click on the Input Columns folder and you will see the the one and only import column, F002_FileLocation. You really only ever need one import column. The important information here is the FileDataColumnID. This is how you will link the file name to the actual BLOB that will be imported. That is to say this is how the computer links what filename to what file. Remember the LineageIDyou copied from the OutputColumn (FileData), it goes in FileDataColumnID (see the image below)
That's it. When you run this component you will now be able to access your imported files via the FileData column. Have fun!