In Sql Server 2008 the support for multi document type / multi format document files is very limited and some workarounds are needed. Without using a script task, even more so.

1. Set up a Flat File source and configure it to read each line as one column.

2. Use a derived column with an expression to extract the type identifier for the row.

3. Pass the flow to a Conditional Split with one output for each type.

4. Write each to a Raw File destination.

5. Using each Raw File as a source, parse the data.

😎