Input from variable and excel to oledb destination in ssis 2012 -


i have situation need data excel sheet , sql table store single sql server table.

below steps have completed already,

1.in control flow, using execute sql task, fetched data sql , assigned variable.

  • 2.then added data flow task in control flow.
  • 3.in data flow added excel source , oledb destination.

when trying edit oledb destination can able see excel sheet columns,

how variables in oledb destination? or there other best approach ?

you need add merge join control inside of data flow task.

probably easier change execute sql task second data source within data flow task , join on key within merge join control.

be warned merge join requires data sorted. if data sorted on input, can tell ssis setting input / output properties of advanced editor. otherwise, can add sort task after each data source.


Comments

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -