Link to home
Create AccountLog in
Avatar of chenyuhao88
chenyuhao88

asked on

How to "do after" in SSIS

Dear All,

In my data flow I read data from source with condition, and copy to my destination db.

After finish, i try to set 1 column in my source table to be "finished".

I could think of putting 1 SQL task in OnPostExecute event handler. However if I don't want to re-write that source condition again, is there any quick way I could do it directly in data flow?


Thanks a lot!
Avatar of Pratima
Pratima
Flag of India image


to Copy data to destination you must be used OLE DB Destination.
After this on Success flow you can add one OLE DB Command
 or Script Componnent.and ad your code here to set column value

In Script component you need to write down code for it
Avatar of chenyuhao88
chenyuhao88

ASKER

Hi pratima_mcs,

My source is OLE DB and my destination is ADO.NET. Is that ok?

yes on succeess flow you can add next command
could I add on success flow in data-flow? Or shall I do it in control-flow?
In dataflow after Ado.net destination , It will have two flows to it..one sucees ..green line and one error Red line
pratima_mcs,

My "ADO NET Destination" has only 1 red error line.
ASKER CERTIFIED SOLUTION
Avatar of Pratima
Pratima
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks!