Thank you for the reply, that is what we are currently doing. I have setup a package that calls all the stored procs that do the dynamic SQL. I was just wondering if there were any SSIS options other then this.