Brandie Tarvin (5/13/2013)
wolfkillj (5/13/2013)
I couldn't use your sample data because the text file formatting seemed to be inconsistent from line to lineExactly. If you check my first post, you'll see where I made that point. That's why we import all rows into a single column in the staging table to begin with.
I need a solution that addresses my current setup, including the inconsistent data.
Handling the inconsistent data is my favorite part of doing it in SSIS, but the other approaches put forward here look good too.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams