Glad the text driver worked, as I said I knew that worked but I thought I had also done it with the excel driver.
You should be able to trim by simply doing something like
Update TableX
Set FieldY = LTRIM(FieldY)
AS far as seing packages in the Stored Packages area in SSMS you need to deploy them there first to be visible. One of the easiest ways it to connect to integration services from SSMS, expand stored packages, and thee file system or msdb (depending on where you want it) and right click and select import package. At that point follow the wizard, as there is too much to explain each step and option.