Martyn Hughes (10/19/2010)
I don't know why you'd want to go to such lengths to use SSIS, just use Pervasive (formerly Data Junction). It's a far superior way of getting data into SQL.
Not everyone can afford third party tools, or get the approval to buy them. Knowing how they could perform this in SSIS is a piece of knowledge that many can benefit from.
If there's a superior way to use Pervasive, perhaps you would want to mention specifically why rather than just add a snarky comment.