msbi - Running a DFT Based on a condition in SSIS -


i've package need retrieve data mysql table , insert sql server table. i've situation in old data gets modified , client wants dump data large , time consuming...so i've come proposal we'd load yesterday's data on week days , complete dump on weekend...is there possibility of enable/disabling dft based on expression? i've tried using expressions->disable based on datepart(weekday,getdate()) runs complete load irrespective of expression's value

regards, vijay

create sql task or script task expression, , set result variable. create data flow task. connect 2 arrow (aka precedence constraint)

then right-click:edit on arror , choose edit, , in precedence constraint editor choose evaluationoperation: expression value: @@yourvariable= {an expression, such @irowsupdated==true}


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? -