SSIS: Import Excel file to SQL Server
If this is a simple Excel file load, you can just use the Import Wizard to create an SSIS package for you (available by right clicking the Database, and selecting Tasks -> Import Data) and even save that package for future use.

If this is a process where you need to take data from an Excel file, transform it, then load it, then yes a custom SSIS package will work better.  You should be able to add a new connection and indicate that it is an excel file using the "new Connection Manager" wizard in your SSIS package.