sql update - Insert excel file into a temp table SSIS package -


what trying have ssis package import excel file sql update on records in excel file. tutorial great

in data flow-->excel source --> ole db command (write sp create stage table (can't insert #temptable ssis, insert stage table, update table)

in ole db command transformation. exec storedprocedure. want create variables in sp used insert. want map columns excel source variables inserted.

sorry, don't have access ssis right unable provide screen shots.


Comments

Popular posts from this blog

css - SVG using textPath a symbol not rendering in Firefox -

Java 8 + Maven Javadoc plugin: Error fetching URL -

datatable - Matlab struct computations -