Well the bad news is...I wasn't able to correct in the DTS ActiveX or Store Procedure. But the good news, I was able to research and found a way...

Thanks,

I apologize, I mispoke what I was trying to accomplish. I'm actually using this on an Import Procedure. I have to rename the Excel Sheet I'm trying to...