Getting an excel file on sharepoint into SSIS

Nov 3, 2011 at 4:23 PM

HI there

I'm a newbie, and my ultimate goal is to upload an excel spreadsheet and create a chart from its contents

I know I need a cube to use charts in KPI,

I have loaded the sharepoint list source and destination, it works fine for the embedded calendar in the team website, but I cannot figure if ( or how) I can use an excel spreadsheet instead of a list

...Help?