Posted: 4/30/2012
Hi everyone,
i have table with some columns, using the data flow task i loading records into oracle table . i wanted to know after migration for a particular column we have to check particular record is present or not. if the record is not their then in the next dataflow task it will fetch from other source and data is loaded . if record is present then next dataflow task should not run.
please Suggest me for this how make use precedence constraint .
Is the record/value you are checking for a fixed thing or variable with every load? To me it sounds more like you should just use a conditional split or a lookup in your first data flow to determine whether or not to run the subsequent load.
Hi Daniel ,thanks for your quick response.
for more information i posted in ;
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/5a4ccc3d-f6b6-4933-947a-ec932052c272
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/df294445-e68e-4b04-bafe-0767e2a6b065
but i didnt get expected result..
please needhelful
Posted: 5/2/2012
Hi Daniel ,thanks for your response.