sql-serverssisssis-2012
How to truncate data in OLEDB DESTINATION dynamically in SSIS?
My source is flat file and and target is OLEDB Destination.my source and destination both have data.
now my requirement is when iam trying to load source to destination i want truncate existing data in destination dynamically and insert new source data. how to implement in SSIS ?
Thanks in advance
PPras'd
Solution
For Acheving the target just go on the Control flow Task and take execute sql task and the right your Truncate script like Truncate table in the Execute Sql task and then connect this to your Data Flow task. From doing this you can achieve
your goal. If have you face any Issue then share here
- Math.Sin() gives incorrect value
- How to run my python script when the sunOS is start booting
- Express-session: not resetting cookie expiration on each request
- Getting a stack overflow exception when normalizing a vector
- Edit default summary function in R gives error for multiple variables
- What was a For loop? Why isn't it needed in R?
- How to use download button in shiny and save results in various formats (csv, texte, pdf, spss...)?
- Why are there two assignment operators, `<-` and `->` in R?
- lm()$assign: what is it?
- How to get the value of list(...) in R and S functions
- Design matrix for MLM from library(lme4) with fixed and random effects
- how to generate elements not included in my sample
- Create a matrix with gradually changing values without a for loop
- Emacs ESS and S-plus ( S+ ) 8.1 compatability
- How to lag date-index in a time-series in R?
- Nonlinear regression in R / S
- Calling R from S-Plus?