Here's a brief overview:
Importing the entire 835 file into a single SQL table, then using stored procedures to parse the segments. Challenges & Best Practices Loop Complexity: SSIS-835