Koen Verbeeck (10/23/2014)

---

Phil Parkin (10/23/2014)

---

Configure your flat file source connection with | as the column delimiter and let SSIS do the work for you. See here[/url] for an example.

Or just create a very simple script component that uses the .NET split function.

Very easy to work with and much easier code to write.