I'm not sure quite what you are doing with Access macros in conjunction with SSIS? Using as a front end you mean that it fires ssis packages??

can you elaborate on the entire process a bit as maybe you need to post in a different forum to get helpful responses, but I'm really unclear on the issue.