It is possible and I have done it since my original post but it is not worth it, too complicated and not worth the effort. It would require some serious automation and involved some .net within the SSIS package.