Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2011-10-28 : 06:21:44
|
| HiI have a Dataflow task. Based on the Dataflow task's success or failure, I have to update a variable with 1 or 0. Please help me finding a way to update variable based on the Data Flow task's success or failure.Thanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-28 : 07:16:26
|
| isnt it enough to add a execute sql task in control flow after data flow task and link them based on onsuccess of data flow task. inside execute sql task assign value of 1 to variable. By default it will have 0 as the value when you declare it.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Dataflow success/failure in variable