Thanks for some direction.  Additional data... This will be an ongoing process and I'll be required to with several Excel files, some will required weekly processing, others daily and at certain point of the month hourly.  Some of these Excel files have more than 65k rows and it is in .xls format so I need to deal with multiple sheets within the excel file.

My issue in not so much creating a DTS Package as opposed to running it from a Stored Procedure.  The data I receive is not clean and I must ETL it before finial processing (I got that covered).  Having the import and the ETL within the same Stored proc is important as the turnaround time is important (source to final).  Or within the same scheduled agent job... but again I am unfamiliar with how to schedule a DTS pkg from the agent...