ssis - Importing Excel data into SQL table via Script component -

this question has answer here:

• script task in ssis import excel spreadsheet 1 answer

i have large excel file different data such text, date, currency etc. found data conversions , derived columns not helpful need lot of conversions , add new output fields. i'm @ c# easy required transformations using script component. want achieve is

excel file -> script componenet -> sql table

i know how add output columns script component, can not find way hook excel script component. how link excel source , read excel data in script component, out opening , reading excel file within script component.

please advise. many john

try ..

for script component ..

add derived columns might need.

in script editor, each row, can reference input columns , derived output columns ..

public override void input0_processinputrow(input0buffer row) {     /*       add code here     */     string dercol1 = "";      if (row.col1_isnull == true)     {         row.derivecol1 = dercol1;     }     else     {         row.derivecol1 = "add text";     }  }